4 Replies Latest reply on Feb 18, 2014 2:50 PM by keywords

    Constrain Found Set not removing Blanks

    pebbert

      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,