2 Replies Latest reply on Jan 31, 2013 6:00 AM by MegS

    Script Searching for Records with Blank Field

    MegS

      Title

      Script Searching for Records with Blank Field

      Post

           So I'm trying to write a script that will search for records where a particular field is blank.  I'm not sure how to signify this in the "Perform Find" step.  I get to specify field then am not sure what to put. 

           If anyone knows I'd greatly appreciate it. 

            

        • 1. Re: Script Searching for Records with Blank Field
          philmodjunk

               While you can specify find criteria in the Perform Find step--including the criteria that searches for records with an empty field. I recommend against it. There's an alternative way to script finds that lists the criteria used as set field steps in the script. This makes it much easier to review the criteria used in a scripted find as you don't have to open up a supplementary dialog box to see what criteria was used in the find.

               The search criterion you can use to find records with a blank field is usually to put a lone = sign in the field. But this will not work if the field is from a related table. In that case you set up an Omit Request that omits all records where there is a related record where the field is not blank. The criterion you use in this case would be the * operator.

               To see some scripted find examples that use Set Field, see this thread: Scripted Find Examples

          • 2. Re: Script Searching for Records with Blank Field
            MegS

                 Thank you!