Help with Find

[trevorg]

How would I put this find criteria together using a CDML link?

In FMP Client I think of it as:

(Name=Joe AND Status=1) (New Request)

(Name=Bob AND Status=1) (New Request)

(Name=Mary AND Status=1)

 

<a href="FMPro?-db=DB.fp5&-lay=web&-format=results.htm& [color:"red"][WHAT GOES HERE?][/color]&-error=error.htm&-Find">Find Joe or Bob or Mary where status is one</a>

[Unable]

Or understanding.

[trevorg]

To verify that I understand the referred thread:

It is impossible to combine the OR and AND criteria, and must be done with smoke and mirrors by first finding all the OR criteria, and then on the results page use an IF statement to only show the records that meet the AND criteria.

I haven't tried this yet, but is this how it MUST be done? What is the performance impact of finding roughly 1,000 records (the OR criteria) and then relying on the IF to reduce this set down about 25 records? (to satisfy the AND criteria)

Also, in the referral thread, Keith

[Unable]

AFAIK, one must be very careful about mixing metaphors. That aside, based on what you have learned; what have you tried; what are the results?

[Anatoli]

For mixing AND and OR web requests I've created calculated field in FM. It was sufficient for all my tasks so far.

[trevorg]

Thank you Anatoli. That makes sense.