Sidebar

How to create an ADT HL7 from a DBQuery

0 votes
1.2K views
asked Sep 6, 2018 by david-m-4997 (120 points)
Hi

I'm evaluating QIE so bear with me. I would like to create an ADT  HL7 from a database query and I have the following questions:

- In the examples I've seen on using DBQuery, it seems a bit odd that the source node is set to DBQuery to get results and then in the mapping node, another query is performed to get results which are used in a mapping function to set mesage node values.

Can you provide an example of how to do this please - thanks.

This seems a bit odd to me but obviously i'm new to this software.

- Once a mapping is working correctly can it (or a whole channel)  be exported and imported into another instance of QIE ?

Many thanks.

1 Answer

+1 vote

Essentially you can query for all of the data you want to retrieve from the database on the source node, however, as a general rule, we like to run smaller queries to reduce the time and number of rows that may get locked while retrieving large amounts of data on the source node.

I like to query for an id and some basic patient identifying data on the source node so that I can search for messages by patient name or id on the message tab later on, and then in the mapping use subqueries to gather all of the other relevant data for a given patient/message.

Here is a channel that can be downloaded as an example.


Once you get the channel you can import it by following these instructions: https://www.qvera.com/kb/index.php/364 which also is how you can export and import a channel from your test server to your prod server.

answered Sep 6, 2018 by gary-t-8719 (14,860 points)
edited May 6, 2020 by gary-t-8719
commented Sep 10, 2018 by david-m-4997 (120 points)
OK thanks, I've imported the channel and will let you know how I get on
commented Sep 28, 2018 by linda-t-7205 (100 points)
edited Sep 28, 2018 by linda-t-7205
Can you send me a channel template for creating X12 278?  First day trying this but I can't get this to work.  I am trying to query a database and create an X12 278 file from it.  Does this require the source to be in the X12 278 format?  I want to produce the file in this format from the data in the database.
commented Oct 1, 2018 by gary-t-8719 (14,860 points)
I sent out a sample channel
asked Feb 25, 2019 by martin-g-6661 (120 points) Can you please send me the channel also?
...