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.

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

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") = ""

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

This is how the whole message looks

I want to get the value 110 from the OBX2 SEGMENT

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?

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

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 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.

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

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 Craig, thank you so much for replying to my query and also sharing an example for me. The above solution helped me.

Regards,

Eric

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

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

No such function found

Regards,

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

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