Results with repeated values

[padmanabanraju]

Hi i am working with an outbound channel, i am able get the output as hl7 files from database reader, I have only 15 rows in my table, But i got lot of repeated values, Is there any way to stop writing files..

thanks in advance

[jbartels]

After reading a row from the database you need to somehow mark it as having been read. I usually have Mirth just set a 'has_been_sent' column to true after it reads a row. Then when you SELECT rows just pick the ones where 'has_been_sent' = false

[nshaik]

You may also refer the following post which has a sample SELECT and UPDATE statement:

Send outbound msg only once and update database column after sending?

http://www.mirthproject.org/index.php?option=com_loudmouth&task=topic&id=239&Itemid=63

[padmanabanraju]

Thanks a lot..