MySQL with AES_DECRYPT in DB reader

[is98049]

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

[albertosaez]

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;