I am having problems with a scripted find I'm creating. The table being searched has about 28,000 records in it. I setup several global fields for the search criteria. Modifying these fields triggers the find script. I am than trying to omit out records that have a statusId of 40 as this means the the items have shipped.
When I search for a particular Printer manually and than constrain it by omitting the statusId of 40 I come up with a found set of 2342.
When I use my scripted find i get a found set of 40.
Any ideas what I am doing wrong?
This is my script
Here is the constrain Found Set