Hi Julius, updated the statements to include the W variant and still doesnt work for me.

I think it could be something with the statement, because a select statement doesnt give me an error. Can you spot anything in the following error message?

Hi Eduard, After using the prepareW statements the select query started working.

I simply deleted the entire function, and re-wrote it again and it now works. Did nothing different, just deleted the function, and copied the code back into the new function.

Cannot understand what the issue was. crazy. but solved now

Eric

Hi Marc, thank you so much. Actually I had to edit my question. My aim is to get the 5th field value from the last OBX segment in my HL7 message. Because I can have varying number of OBX segments but I know that the value I want is in the last OBX segment. 

So I thought if I could get the number of segments in a message, and then index that to get the last segment I could get the value I want.

Is there a better way to do that?

Sorry for the confusion. Appreciate your help

Thank You Marc, I tried that in my function, and its giving me the following error

No such function found

Regards,

Eric

Thank You Guys, I found the method, and used your advice to getValueat(), this solved my question.

Hi Craig, thank you so much for replying to my query and also sharing an example for me. The above solution helped me.

Regards,

Eric

Hi Cristiano, 

thank you for getting back to me. You were right, our end point was down, and automatically the adapter was dequeued. As soon the connection was re-established it worked. 

The adapter status confused me, sorry. 

thank you so much. 

Regards,

Eric

Hi Vic, 

Thank you for reviewing my question. I had to censor everything :) but the adapter status changed as soon as the end point was connected. I thought it was a status that I had to update on the job and that confused me. 

Regards,

Eric

Thank you for responding to my question Vic. Ok, thats a start, I will check the events and see if there is anything causing the dead jobs.

Thank You Vic, somehow the job stopped before I could run out of space (10GB). I was reading the docs and it said that there is no way of reversing the operation, panicked. Really appreciate for sending the details along.

Thank you so much Chris, I had to add the parentheses. Thank you for giving me the idea of referencing with the field number. I used to type the whole lot. This works faster.

Regards,

Eric

Hi Cristiano, Thank you so much,  I tried that too, but always returns blank.

pRequest.GetValueAt("PIDgrpgrp(1).ORCgrp(1).OBXgrp(2).OBX:6"). Is my syntax wrong?

I want to get the value 110 from the OBX2 SEGMENT

This is how the whole message looks

spot on Cristiano.  I will need to find a way to identify the segment and get the value. Thank you so much.

Hi Robert, I am getting the list in an excel file, and thinking I could use a straight global to load the values and compare. Is that a good way?

^EDLIST("DIAG", "X123, internal health") = ""

^EDLIST("DIAG", "X234, External health") = ""

Hi Marc, thank you so much for that. This is a new thought process for me. 

HI Robert,  thank you, I was able to use your advice on implementing the code. What does the #10 do? I was able to use your suggestion because I already had a Business Process defined, which I could just plug in your suggestion.

Thank You Robert, got it in by the following code

set file=##class(%Stream.FileCharacter).New()

do file.LinkToFile("c:\location of csv")

for quit:file.AtEnd set ^GLOBAL($piece(file.ReadLine(),",",1),$piece(file.ReadLine(),",",*)=""

Hi Vic, I am adding to an already existing function and its a bit of just adding this bit and using it. Is there a way to use the $data function to read the subscript1 of a global? Like $data(^GLOBAL("123"))? I just want to read the first part of the Global

Hi Kurro, yes that is a typo, sorry. for some reason it isnt getting into the segment. Do you think I should first clear the segment and then set the value?

Hi Kurro, once I make the change, should I be updating the segment?

I am doing a findSegment again? is that wrong?

Below is an example of the HL7 we get, it comes as a 0 , I want to replace it with "No code"

Thank you Eduard, but how do I set the SendRequestSync?

my input is EnsLib.HL7.Service.TCPService and my BO  - send is EnsLib.HL7.Operation.TCPOperation. Can I still use it? I see that my input has the option for ACk setting. Will your method work if I set it to Application?