AnsweredAssumed Answered

Scripting an "and" for a found set

Question asked by Kirk_1 on Nov 13, 2012
Latest reply on Nov 19, 2012 by philmodjunk

Title

Scripting an "and" for a found set

Post

     How do i script an "and" for a found set?

     I want it to find every thing that has the field "ok to clear" and "pending" checked. The 1 is Boolean and the x is a place holder...

     If i put them together in the script like i have it below, it will only find the items that have both checked.

         
  •           Go to Layout [ “Clear Invoices” (Invoice) ]
  •      
  •           Enter Find Mode [ ]
  •      
  •           Set Field [ Invoice::INOkToClear_calc; "x" ]
  •      
  •           Set Field [ Invoice::INPending; "1" ]
  •      
  •           Perform Find [ ]
  •      
  •           Sort Records [ Specified Sort Order: Invoice::INShipmentDate; ascending ] [ Restore; No dialog ]

Outcomes