Announcement

Collapse

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

Error parsing SQL sentences

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

  • Error parsing SQL sentences

    Hi all,

    I found that Mirth 1.7 has many problems parsing many complex SQL sentences like:

    SELECT tabla1.code+convert(char(8),(SELECT TOP 1 description FROM tablazzz WHERE zona=tabla1.code)) as total FROM XXX tabla1 LEFT JOIN YYY tabla2 ON tabla1.code=tabla2.code

    At this point Mirth is unable to parse "total" as a result of this sentence.

    Any hints,

    Ricardo Bernat

  • #2
    Re:Error parsing SQL sentences

    Try moving the SELECT to a database view and in Mirth change the SQL statement to use the view instead of the base tables.

    Hope this workaround helps!

    Comment

    Working...
    X