Multiple search

[chris_brown]

Hi! could someone please tell me if it's possible to search for 2 different criteria in one field? for example for the search to just show the sales reps AC and LR. Is this possible.

Thanks for any advice.

CHRIS.

[CobaltSky]

Yes Chris,

It is possible to run two find requests simultaneously.

What you need to do is go into Find mode and put in your first criterion (ag AC into sales reps). Then, before you proceed with the find, go to the Requests manu and select the Add New Request command. That will give you a second find request into which you can enter your second criterion (eg LR into Sales reps).

Now when you press enter or click 'Find' to proceed, both sets of criteria will be part of the search and the found set will combine all the records which met either criterion.

[LERC Assistant]

Is there anyway to script this?

[Søren Dyhr]

Yes one line makes it posible to hardwire inside the requests:

Perform Find[

...you can then use the Modify Last Find, to alter the hardwired via scriptparamters or such. This can be done this way:

Set Error Capture [ On ] 

Perform Find [ Specified Find Requests: Find Records; Criteria: trib::sales_reps: “AR” Find Records; Criteria: trib::sales_reps: “LR” ] [ Restore ] 

If [ Length ( Get ( ScriptParameter ) ) ] 

      Modify Last Find Set Field [ trib::sales_reps; MiddleValues ( Get ( ScriptParameter ) ; 1 ; 1 ) ] 

      Go to Record/Request/Page [ Next ] 

      Set Field [ trib::sales_reps; MiddleValues ( Get ( ScriptParameter ) ;2; 1 ) ] 

End If Perform Find [  ] 

Set Error Capture [ Off ] 

The way it works is if the script is overloaded with two return delimited values in the scriptparameters, are each considered a requestvalue, otherwise will the script find the default two salesmen. You could build it further to accept even more values by looping beyond the two hardwired, by including a New Record/Request step for each paramter in excess of the two.

--sd