Database Sender¶

QIE can be configured to write message data directly to one or more database tables.

Connection¶

Select the desired database connection from the connection drop-down list (see Managing Database Connections for information on managing database connections).

Update Statement (Stmnt)¶

Enter the SQL Insert or Update statement that is used to write the message data to the database. SQL insert and update statements can contain embedded node tags (see Node Paths and Node Tags for more information).

Reference values from the message with {m:NodePath} (current state, including any mapping-node modifications) and from the original source with {s:NodePath}. The Update Statement is raw SQL, not a JavaScript expression. Do not call getNode() or other script functions here; the node-tag template runs before the SQL is sent to the database.

Example: write a patient's MRN and admit date from an inbound ADT message to a tracking table:

INSERT INTO admissions (mrn, admit_date, source_message_id)
VALUES ('{m:PID-3.1}', {m:PV1-44[yyyy-MM-dd HH:mm:ss]}, {SOURCE_ID})