web stats
Send HL7 message with multiple OBX? - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 02-25-2011, 08:24 AM
upstart33 upstart33 is offline
Mirth Guru
 
Join Date: Dec 2010
Location: Chicago, IL.
Posts: 459
upstart33 is on a distinguished road
Default Send HL7 message with multiple OBX?

Hi,

I have a SQL Database Reader channel that gathers lab results and creates an HL7 message. Currently, it is sending 1 message for each patient result.

My current PROC gathers up all the results in a temp table and returns them by row, 1 at a time. Thus, it is creating 1 HL7 file per result.

Does anyone know a way where I can send all of the results for a patient, for a certain day, in 1 HL7 file? Basically, I wish to have multiple OBX sections attached to 1 MSH.

I know I will probably have to use some sort of Javascript, but I am not sure where to use it or how to begin writing it.

Any help would be appreciated.
Reply With Quote
  #2  
Old 02-28-2011, 12:35 PM
upstart33 upstart33 is offline
Mirth Guru
 
Join Date: Dec 2010
Location: Chicago, IL.
Posts: 459
upstart33 is on a distinguished road
Default

If you wish to have multiple OBX segments in 1 outbound HL7 file, do you have to format you SQL source query to return the results this way or can your query return 1 result per row, and you use transformers in the channel to build the message with the multiple OBX's? I am so confused...
Reply With Quote
  #3  
Old 02-28-2011, 12:59 PM
dans dans is offline
Mirth Employee
 
Join Date: Apr 2007
Location: Irvine, CA
Posts: 590
dans is an unknown quantity at this point
Default

You could have one query in the DB Reader pulling the patient info in. Then you can have separate queries pulling in the results in your transformer.
__________________
Daniel Svanstedt
Software Engineer
Mirth Corporation

Want professional services, support, and enterprise or virtual appliances? It's all available from the Mirth Corporation:
Mirth Support | Mirth Training | Mirth Appliances | Online Training | Developer Q&A

Don't forget, Mirth Support gives you access to all of our online training videos, and silver support gives you access to developer Q&As!
Reply With Quote
  #4  
Old 03-01-2011, 06:15 AM
Jurjan Jurjan is offline
OBX.1 Kenobi
 
Join Date: Feb 2011
Posts: 37
Jurjan is on a distinguished road
Default

This sounds exactly like my problem (but perhaps better stated?).
link to my post
I can get stuff out of my driving query into variables in my transformer.
but I don't get the detail query, how do I define it, how do I use the results from the driving query to steer the second query?
Sorry for hijacking your thread.

Thanks
Jurjan
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 08:43 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation