don't know what you are missing but I do know what we are missing... the criteria in your constrain step.
Can you double-click it and show us what's inside ?
I added it to the original.
Why didn't my omit - omit? It should have. I went to the constrain to solve the issue of it not omiting.
I verified that those 2 fields have the Boolean 1 in them.
So this isn't an answer to your question, but since there is an omit in the Find before the Constrain, the Constrain is doing the same thing.
This may help:
Maybe add another New Record/Request (and an Omit) inbetween the SetField [Invoice...] and SetField [Customer...]
Because it seems to be omitting only record that have both with the boolean value of 1, instead of either one or the other. (or I may be understanding this incorrectly)
The omit and constrain are no omiting the bolean fields.
In the same record or different records?
i now have 13 records in this found set.
1 record has isaudit = 1
8 recirds have isdls = 1
Just to clarify, it looks like you want to first find all records that are both INOkToClear = "yes" and have any value in INPostedDate.
From that found set you want to omit any records that are both IN_isDLS = 1 and IsAuditAccount = 1.
To make things easier to follow I'd suggest removing the second request when in find mode and just use the Constrain Found Set command to filter your results. From your description I'm not sure whether you want to remove only records that are both IN_isDLS = 1 and IsAuditAccount = 1, or records that are either IN_isDLS = 1 or IsAuditAccount = 1. If you are trying to achieve the later, your Constrain Found Set command should have two actions, one for each criterion rather than both in the same.
Hope that helps.
Ype thats it... i have... and
I want... or
In both found sets...