Constrain Found Set

Narrows the existing found set using the current or stored find requests.

Options 

Specify find requests allows you to create and store a find request with the script step. Restore indicates a stored find request.

Compatibility 

Product Supported
FileMaker Pro Yes
FileMaker Go Yes
FileMaker WebDirect Yes
FileMaker Server Yes
FileMaker Cloud products Yes
FileMaker Data API Yes
Custom Web Publishing Yes

Originated in version 

6.0 or earlier

Description 

This script step is equivalent to a logical AND search. Otherwise, Constrain Found Set is similar to the Perform Find script step.

Notes 

  • If no records match the find criteria, this script step returns a found set of zero records.

Example 1 

Constrains the found set to paid invoices or shows all records.

Copy
Show Custom Dialog ["Display only paid invoices?"]
If [Get ( LastMessageChoice ) = 1]
Enter Find Mode [Pause: Off]
Set Field [Invoices::Status; "Paid"]
Constrain Found Set [ ]
Else
Show All Records
End If