Qvera: Getting rid of quotes from a CSV file

When creating a .csv file in Qvera, the message has double quote text delimiters by default.  If you are seeding your message from a SQL query for example, the values will be surrounded by double qotes. “PatientID”,”PatientName”,”DOB”,”Etc”,”Etc” You can reformat the message by saving the message to a temporary variable, and reformatting it using createCSVMessage […]

MU Activity Log

ADD_MUACTIVITY_LOG() is another undocumented symbol that can come in handy. At Blackbird, we use this when we want to record that a handout has been printed. It would be natural to store it in an OBS, but because the CQR reporting system looks in the activity log to see whether or not to count these events, […]

Getting a List of All Users

The MEL function to get lists of users takes, as a parameter, a list of locations of care.  However, what if you are writing code where you want all the users and don’t know what locations are in the system where the code will be running? The answer is that you can get the root […]

Locations of Care

An interesting problem came up this week.  We encountered a situation where the we needed a document’s location abbreviation instead of the full name. Centricity supports several expressions that retrieve the locations, but not all methods include the abbreviation: DOCUMENT.LOCOFCARENAME DOCUMENT.LOCOFCARE (undocumented) PATIENT.HOMELOCATIONNAME PATIENT.HOMELOCATIONABBREVNAME USER.CURLOCATIONNAME USER.CURLOCATIONABBREVNAME USER.HOMELOCATIONNAME To get the abbreviation for the document’s location, […]