Announcement

Collapse

NextGen Connect 3.10.1 Released!

NextGen (Mirth) Connect 3.10.1 is now available as an appliance update and on our GitHub page. This release contains bug fixes. See the release notes for the list of fixes.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

query mirth database for stored messages

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

  • query mirth database for stored messages

    hello,

    I want to set up a javascript filter that loops through all messages that have already been processed by the channel.

    sample: the current message has a value PID=12345
    filter: lookup all stored messages if any message has a value of PID=12345. if so, drop the current message.

    background: the channel queries a database where I have only read rights. so I can't write an update statement that tags the processed columns as 'done' or something.

    is this possible or are there any other ways to filter out the messages that have been sent?

    thanks,
    svart
    svart
    OL/Germany

  • #2
    Re:query mirth database for stored messages

    That is the point of the filter in Mirth. You check if a field is the value that you want it to be. If a field contains data that you want to filter, return false, otherwise return true.
    Brendan Haverlock | Mirth Software Engineer | Mirth Corporation

    Comment


    • #3
      Re:query mirth database for stored messages

      The point is: I don't have a field in that other database that can be used for a filter.
      (like 'processed'=0 or 1)
      Anyway, I downloaded Mirth 1.5. and use postgres as it's database. now I can query the mirth database from a mirth filter :-) seems a bit odd but works great !
      svart
      OL/Germany

      Comment

      Working...
      X