AnsweredAssumed Answered

Constrain Found Set not removing Blanks

Question asked by pebbert on Feb 18, 2014
Latest reply on Feb 18, 2014 by keywords

I am searching through invoices in a script fist by date and then if a checkbox is selected, I want to omit all records that aren't in the selected ship state.


My problem, any international shipment that has a blank state is not omitted.


I am setting a variable $ShipState to the selected state and then omitting records with a Constrain Found Set greater than $ShipState and less than $ShipState. Hopefully leaving records with only the ship state selected.


Any reason why blank ship state records are not being filtered?


Thank you,