query mirth database for stored messages

[svart]

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

[brendanh]

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.

[svart]

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 !