AnsweredAssumed Answered

Scripted Find with a constraint

Question asked by keithstehlik on Mar 28, 2017
Latest reply on Mar 29, 2017 by philmodjunk

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

Outcomes