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

Long SQL Statements in Javascript

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

  • Long SQL Statements in Javascript

    Hello all,

    I wanted to ask you if there is a way to write long quieries in the Javascript-Transformer that aren't on one line. For example:

    Code:
    SELECT tblnarkosen.Fallnummer, tblnarkosen.Protokollnummer, tblstammdaten.IdExtern, tblebm.LeZiffer, tblebm.inserttime, tblebm.Menge, tblstammdaten.Name, tblstammdaten.Vorname, tblstammdaten.Geburtsdatum 
    FROM (SELECT LeZiffer, inserttime   
    INNER JOIN (tblstammdaten 
    INNER JOIN tblnarkosen ON tblstammdaten.Nummer = tblnarkosen.Nummer) ON tblebm.Protokollnummer = tblnarkosen.Protokollnummer 
    WHERE ((tblebm.statusCodeHL7)>200 AND (tblebm.statusCodeHL7)<300) ORDER BY Protokollnummer
    instead of:

    Code:
    SELECT tblnarkosen.Fallnummer, tblnarkosen.Protokollnummer, tblstammdaten.IdExtern, tblebm.LeZiffer, tblebm.inserttime, tblebm.Menge, tblstammdaten.Name, tblstammdaten.Vorname, tblstammdaten.Geburtsdatum FROM (SELECT LeZiffer, inserttime    INNER JOIN (tblstammdaten INNER JOIN tblnarkosen ON tblstammdaten.Nummer = tblnarkosen.Nummer) ON tblebm.Protokollnummer = tblnarkosen.Protokollnummer WHERE ((tblebm.statusCodeHL7)>200 AND (tblebm.statusCodeHL7)<300) ORDER BY Protokollnummer;
    So I could increase the understandability of my query.

    Thanks a lot for any help!

    Greets,

    Svetlomir

    Post edited by: Svetlomir Kasabov, at: 09/12/2008 08:25

  • #2
    Re:Long SQL Statements in Javascript

    YES!

    http://www.mirthproject.org/index.ph...9&catid=2#6769
    Jon Bartels

    Zen is hiring!!!!
    http://consultzen.com/careers/
    Talented healthcare IT professionals wanted. Engineers to sales to management.
    Good benefits, great working environment, genuinely interesting work.

    Comment

    Working...
    X