Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 5995 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted (edited)

Hi,

I need to develop some logic like.

Enter Find Mode

Set Field ["Multiple searching criteria seperated by some breaking characters."]

Perform Find

Must have got my requirement.

I dont want to use separate, more than one set field script step to get data satisfying multiple search criterias.

Is there any separators available, by which we can combine multiple searches in to one and get the required data?

Is this possible in Find Mode?

Edited by Guest
Posted

You mean sort of diagonally search across all fields in the record, perhaps obviusly avoiding the date/time and container- fields?

If so turn to the Perform Find command, and build a list of request long enough to encompass all the required fields. Each request is then filled with the same daft value avoiding any matches. This should be enclosed in an error capture clause.

The user enters something in a global field to seach for, which then is:


If [ Length ( Untitled::theGlobal ) ] 

     Set Error Capture [ On ] 

     Perform Find [ Specified Find Requests: Find Records; Criteria: Untitled::filedA: “çfç” 

          Find Records; Criteria: Untitled::filedB: “çfç” 

          Find Records; Criteria: Untitled::filedC: “çfç” 

          Find Records; Criteria: Untitled::filedD: “çfç” 

          Find Records; Criteria: Untitled::filedE: “çfç” 

          Find Records; Criteria: Untitled::filedF: “çfç” 

          Find Records; Criteria: Untitled::filedG: “çfç” ] [ Restore ] 

     Modify Last Find 

     Perform Find/Replace [ Find: "çfç"; Replace: Untitled::theGlobal; Search operation: Replace All; Search settings: Forward; Search across: All records/requests; Search within: All fields ] [ No dialog ] 

      Perform Find [  ] 

      Set Error Capture [ Off ] 

      If [ Get ( FoundCount ) xor 1 ] 

           Show Custom Dialog [ Message: "Nothing found!!!!"; Buttons: “OK” ] 

           Show All Records 

     End If 

End If 

--sd

This topic is 5995 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.