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.
Find without indexes doesn't use the indexes of criteria fields. If the criteria fields are indexed and the current found set is already a small subset of the total number of records in the table, then this option may improve the performance of a constrained find.
Compatibility
| Product | Supported |
| FileMaker Pro | Yes |
| FileMaker Go | Yes |
| FileMaker WebDirect | Yes |
| FileMaker Server | Yes |
| FileMaker Cloud | 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