"OR" function in Find Request script

[mdfOffman]

How do you create an OR function in a Perform Find script step?

[comment]

In order to perform an OR find, you need to create a separate find request for each predicate. These requests can be specified and stored in the Perform Find script step. For example, to find records where the name is Adam or Betty, it would be set up as:

If you prefer, you can do the same thing by:

Enter Find Mode [ ]
Set Field [ Table::Name; "Adam" ] 
New Record/Request
Set Field [ Table::Name; "Betty" ] 
Perform Find [ ]

The advantage here is that you can see at a glance what the search does, without drilling into the stored requests.

 

 

[mdfOffman]

Thank you so much.  I thought of that but I thought they would be AND conditions.  I guess I should have tried before asking ......

Thank you again

[comment]

32 minutes ago, mdfOffman said:

I thought they would be AND conditions

AND conditions would be specified within the same request.

Note also the Extend Found Set and Constrain Found Set steps that provide additional OR an AND functionality, respectively.

 

[mdfOffman]

Thank you again.  You proactively answered my next question  :-)

[mdfOffman]

Thank you so much for the time to help me.  After much internal debate and testing, I decided to surrender and create a "Mirror DocLinks" script.  This, of course doubles the size f the join table but I found it the simplest and most reliable way.  It works just fine though you have to be careful with the delete script which needs to delete both records but not any other records to which field 2 is connected.

Thanks again

[comment]

I think you posted this in the wrong thread?