How to create an ADT HL7 from a DBQuery

Question

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.

Answer 1

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.

Comments

OK thanks, I've imported the channel and will let you know how I get on

---

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.

---

I sent out a sample channel