Announcement

Collapse

Mirth Connect 4.1.0 Released!

Mirth Connect 4.1.0 is now available as an appliance update and on our GitHub page. Mirth Connect 4.1.0 includes new features such as new event log messages, additional fields to the Welcome to Mirth Connect screen, new information included in alerts as well as many smaller changes, updates, and improvements. This release also contains several 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

MySQL with AES_DECRYPT in DB reader

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL with AES_DECRYPT in DB reader

    Hi,

    I am using MySQL to store the transformed HL7 XML message. Since the messages we plan to capture are production data, we need to encrypt them. Thus, I need to use AES_DECRYPT function to decode the encrypted messages.

    The problem is the SQL statement in the DB reader of the channel.

    Only msgid show up as variable; not HL7XML. Please advise the possible solution for this.

    SELECT msgid,AES_DECRYPT(HL7XML,'123&#039 FROM inbound where sendstatus = 'N' and interface = 'Affinity' and buildnum = '111' order by msgid limit 1;

    Thank you very much,

    Charles

  • #2
    Re: MySQL with AES_DECRYPT in DB reader


    SELECT msgid,AES_DECRYPT(HL7XML,'123&#039 as HL7XML FROM inbound where sendstatus = 'N' and interface = 'Affinity' and buildnum = '111' order by msgid limit 1;

    Comment

    Working...
    X