I wrote a query to find usages of the deprecated serializer calls in Mirth channels

[jonbartels]

Newer versions of Mirth will spam the logs if you use old-style serializer calls:

The getHL7Serializer() method is deprecated and will soon be removed. Please use the "Convert HL7 v2.x" templates from the References tab instead. Look at the tooltips to see the available property keys. The new method will strip namespaces by default unless the 'stripNamespaces' property is set to false. 

I wrote a query to find usages of these deprecated calls. It runs on Postgres 12. It returns the channel name and if it found the snippet in the source or destination connector.

This is useful for fixing usages of deprecated method calls when the error message does not tell you what channel is making the call.

This is obviously adaptable for any other find-usages cases you might want to use.

with chan_xml_parse as (
select xmlparse(document channel) as chan_xml, name, channel as chan_raw
from channel c
)
select
name,
xpath('//text()[contains(.,''getHL7Serializer'')]', chan_xml)::text,
xpath('name(//text()[contains(.,''getHL7Serializer'')]/ancestor::sourceConnector)', chan_xml)::text in_source_connector,
xpath('name(//text()[contains(.,''getHL7Serializer'')]/ancestor::destinationConnectors)', chan_xml)::text in_dest_connector
from chan_xml_parse c
where chan_raw like '%getHL7Serializer%';