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,

Outcomes