No announcement yet.

Send HL7 message with multiple OBX?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Send HL7 message with multiple OBX?


    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.

  • #2
    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...


    • #3
      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!


      • #4
        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.