Question Jonathan Anglin · Jan 6, 2022 Searching messages and using EnsLib_HL7.Message.RawContent in DTL Problem to Solve: When an HL7 message hits a particular Process, I need to use the placer order number therein to query the messages that came in over the last 24 hours on a particular Service and grab discrete pieces of data that came in the latest message that has that placer order number. The code I'm (currently) using looks like this: #DTL #Message Search #SQL #Ensemble 0 4 0 639
Question Jonathan Anglin · Jun 29, 2021 Problem with Dynamic SQL parameterized UPDATE vs INSERT Hello All I'm running into an issue performing UPDATES that I'm not getting on INSERTS. It's probably obvious, but I'm just not seeing it and could use a little help. I'm going over an HL7 message and depending upon varying criteria, the relevent variables will get items added to them like the following: Set patientId = pRequest.GetValueAt("PID:3") Set sqlColumns = sqlColumns_",patient_id" Set sqlValues = sqlValues_",?" Set par($i(p)) = patientId After compiling the variables, I check to see if accession number is found in the table. #ObjectScript #SQL #HealthShare #InterSystems IRIS 0 14 0 538
Question Jonathan Anglin · Jul 16, 2020 Routing Rule: Same Target, Different Transforms I send ORUs to a process where a transform is applied before sending the message to a process where the routing is handled. A recent request was made that when OBR:25="D" the message is also be faxed with transforms that have some similarities to the original, but not exactly the same. I copied the DTC, made the alterations, and created a separate rule to handle it. However, when I run a message through with a "D" in OBR:25, it is only sent to the routing process once. #HealthShare #InterSystems IRIS 0 3 0 272
Question Jonathan Anglin · Jul 7, 2020 DTL vs. ObjectScript As I've become a little more familiar with HealthShare, I'd like to start exploring different ways of doing things. To date, the bulk of my data transformations have been using DTL; only using ObjectScript for a few operations that write to external SQL tables that were largely based on examples provided by my sales engineer. #DTL #ObjectScript #HealthShare 0 4 0 378
Question Jonathan Anglin · Jun 18, 2020 Get count of substrings within a string I have a code tag that performs some logic in a DTL, and want to add to it the ability to find the number of substrings delimited by a dollar sign ($) within a particular string. I have tried the following which compiles just fine, but generates an error when testing in the Data Transformation Builder. #ObjectScript #HealthShare #InterSystems IRIS for Health 0 3 0 803
Question Jonathan Anglin · Jun 2, 2020 How to get offset for a given timestamp, allowing for DST Hello All I'm not sure what the best practice is for this. I have a DTL for returning ORUs back to a hospital in a different time zone. They have requested that various timestamps have the time zone offset added to the HL7 format (%q%k, I think). First, I just wanted to be sure the system was aware it was DST. I was able to determine if DST is in effect like this: #DTL #ObjectScript #HealthShare 0 5 0 816
Question Jonathan Anglin · Jan 28, 2020 Multiple Emails from EnsLib.EMail.OutboundAdapter I'm trying to tie IRIS (2019.1) into our Concord Fax cloud-based email-to-fax workflow. We have some sites that require a fax be sent to multiple locations based upon certain data (ie Radiology and Emergency departments). Unfortunately, CC-ing does not work with Concord Fax so I need a way to send the email, change the recipient, and then send it again if certain criteria are met. Is this possible? Do I need to duplicate and rename the method, calling the second one in the MessageMap? Here's what my code currently looks like: #Business Operation #Interoperability #ObjectScript #InterSystems IRIS 0 2 0 254
Question Jonathan Anglin · May 7, 2019 LDAP Configuration "user...not found" Hello All! #LDAP #Caché #HealthShare 0 3 0 4.3K