Question ED Coder · Aug 30, 2019 How to get number of segments in a hl7 message and then pull a field value from the last segment Hi, Is there a way to count the number of segments in a HL7 Mesage? I tried the examples from the other answers but nothing works for me.I am writing a function to get the last OBX segment field value 5. Below is a sample screenshot of what I want.The number of obx segments can change, so I want to count the last obx segment and then get the field 5 value.Would appreciate some guidance on this. #Ensemble 0 10 0 3K
Question ED Coder · Aug 16, 2019 Data not getting inserted into mySQL DB Hi, I am trying to get my values into a mySQL DB but for some reason it doesnt seem to go into the DB. I do not get any errors. Would appreciate some guidance on this. #Ensemble 0 17 0 433
Question ED Coder · Aug 15, 2019 Connecting to MYSQL ODBC Hi, Is there a way to connect to a MYSQL ODBC? I tried using the SQL Connect class but getting an error. #SQL #InterSystems IRIS 0 6 0 1.3K
Question ED Coder · Jul 31, 2019 Remove a segment from the HL7 Message Hi,I have a ORU message, which has a EVN segment that I want to remove and send the message across.I tried to clone the request as below:s newreq = request.constructClones changreq = newreq.RemoveSegmentAt("EVN")Set request = changereqbut it fails. Is there a way that I can safely remove a segment and pass it on?Would appreciate your help in thisRegards,Eric #HL7 #Ensemble 0 13 0 1.9K
Question ED Coder · Jul 16, 2019 How to separate OBX segments based on . Hi, I am trying to transform a message to meet a third party specification, and would like to know if you can advice me on how to separate a single OBX segment into several segments based on a '.'I would like to separate the segment where the . [marked in red] is into another OBX segment. So the next segment would be: #ObjectScript #Ensemble 0 8 0 1.1K
Question ED Coder · Mar 7, 2019 Processing certain messages from Queue Hi,I would like some help/ information regarding queued messages.I have 1040 messages that are queued, but I only want to process the first 28 of them. Is there a way that I can do that?If I abort them, would all of them go away?Would appreciate if you can advice me on thisRegards,Eric #Ensemble 0 1 0 697
Question ED Coder · Jan 30, 2019 How to resolve Error#6023 Query not prepared Hi, please can you help me. I cant understand a thing on how to resolve this. I can run the query perfectly fine on SQL but when I run it in studio, it gives an error. #Studio #Ensemble 0 6 0 700
Question ED Coder · Dec 24, 2018 Mirror Monitoring issue, status saying down even if it is running Hi, would really appreciate your advice on how I can restart the mirror-monitor. I've followed the instructions and restarted the mirror monitor, and still the status seems to be down. Can you point me to some resource or steps that I can follow ?I logged into %SYS terminal and restarted the mirror monitor and it says that it is running #Mirroring #Ensemble 0 9 0 663
Question ED Coder · Dec 5, 2018 Schema not appearing on Mirror Hi, I updated the schema on our live node, but the change did not occur on the mirror server. Is there some setting that I need to enable? Everything else seems to be updating but the schema has notCan you advice on what I could be missing or is this something that is known?Regards,Eric #Mirroring #Ensemble 0 2 0 285
Question ED Coder · Nov 19, 2018 Copy csv data into a global object Hi, I have a CSV file with a list of 5000 records in the following format Name, Acc, division Eric, 1234, 567 John, 1235, 987 Peter, 3214, 879 I just want to copy the Acc, division to a global so eventually the global would be like the following: ^People("Customers", "Acc.division") Can you advice on how I can perform this from the terminal? This is a one time task. I want to read all the values from the csv file and insert them into the global Regards, Eric #.NET #CSV #Ensemble 0 7 0 988
Question ED Coder · Nov 6, 2018 ObjectScript: Looping over a multidimensional global value and comparing Hi,I have a global that holds users name and date of birth.I would like to loop through them and check if the date of birth is more than 2 years based on todays dateso I have ^checker("under2", "Eric David", "02-05-2018")I want to check the birthdate based on todays date to see if it is greater than 2. How do I access the birthdate in the globalPlease can you adviceI tried : #Ensemble #ObjectScript 0 9 0 1.2K
Question ED Coder · Nov 6, 2018 ENSEMBLE: What Adapter do I use for simply running a global check in Ensemble Hi, I want to create a service which on start will simply go through a list of values in a global and compare dates. If criteria is met, it will send an email.But what kind of Adapter do I use? I see SQL, FILE, HTTP etc..etc.. But I dont want to use themPlease can you advice on how I should go about this?Should I create a BS. Class and do onAdapterTASK() and simply build a method? Even then it is asking the kind of adapter I wantWould appreciate some guidance on thisRegards,Eric #Ensemble 0 8 0 397
Question ED Coder · Oct 17, 2018 Removing the first two characters in a string Hi,This must be a really easy question but for some reason I am unable to do thisI have a string name = "ERRORMSG"I want to remove the first 2 characters in the string, so the result should be string newname = RORMSGPlease can you advice on how I can do this? #ObjectScript #Ensemble 0 10 0 1.3K
Question ED Coder · Sep 18, 2018 getting an error: Method does not exist when trying to create a file I am trying to create a file from within a zen page but it keeps giving me a method does not exist errorin my page, i am taking the values and writing them to a file, when I do this : #ObjectScript #Caché 0 2 0 508
Question ED Coder · May 16, 2018 Unable to send Emails to distribution list Hi, I'm trying to send emails to a distribution list but it doesnt work. However, When I send emails to individual emails it works fine. Is there a configuration that I need to be checking or enable? I'm doing it within a Business Operation: #Caché #ObjectScript 0 7 0 546