AnsweredAssumed Answered

How to set a script IF ( Found Set = 0 )

Question asked by ezeitgeist on Aug 10, 2017
Latest reply on Aug 10, 2017 by philmodjunk

I am doing a Search whose search terms could be in 1 of 2 fields in a table.

 

What is the best way to perform a find/constrain found set, and then IF that results with 0 records returned to check the 2nd field?

 

Would this work?:

 

Enter Find Mode [ Pause: Off]

Set Field [Main::Field1 ; Main::gSearch ]

Perform Find

If [ Get ( FoundCount ) = 0 ]

Show All Records

Enter Find Mode [ Pause: Off]

Set Field [Main::Field2 ; Main::gSearch ]

Perform Find

If [ Get ( FoundCount ) = 0 ]

Show All Records

Show Custom Dialogue [ "No Records Found" ]

End If

End If

 

Message was edited by: Evan Zeisel Updated to better initial potential script

Outcomes