Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

writing integers to Postgres via data writer

  • Filter
  • Time
  • Show
Clear All
new posts

  • writing integers to Postgres via data writer


    I am very new to Mirth and just trying to understand the basic constructs. We are currently looking at replacing an eGate drive for a small CIS. The eGate interface is structured to write the message id as an "int" to an int field in the CIS Postgres database. I have been strugling to replicate this with Mirth. A simple question - is it possible to write (convert) an data variable integer via an INSERT statement? We are using a simple transformer to disect messages and then passing data as ${msg_id} via an INSERT statement. If it is possible - what would be the syntax?

    Thanks in anticipation


  • #2
    Re:writing integers to Postgres via data writer

    Ok - so I may have answered my own question - is this a reasonable approach?

    INSERT IGNORE INTO record (msg_id,msg_date_time) 
    VALUES (TO_NUMBER(${msg_id}, '99999999'),DATE(${msg_date_time}));