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 on filter

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

  • Error on filter

    Hi all,

    I'm trying to filter many messages querying a database but I can't do it bec ause system returns an extrange message : "Array index out of range: 0".

    This is the script:

    var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbc:jtds:sql server://localhost:1433/mytable','sa','*********');
    var resultado = dbConn.executeCachedQuery("SELECT pacidx from dexpacie WHERE nif='" + msg['nif'].toString() + "'");
    resultado.next();
    var nid=resultado.getFloat(1);
    logger.info('filtro: ');

    if (nid == null)
    var respuesta = false
    else
    var respuesta = true;
    logger.info('filtro: ' + nid);
    dbConn.close();
    return respuesta;

    At this point, no logger information, just a silly error!.

    Anyn hints?,

    Ricardo Bernat
Working...
X