Reference > Script steps reference > Found Sets script steps > Constrain Found Set
 

Constrain Found Set

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

See also 

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 Advanced 

Yes 

FileMaker Go 

Yes 

FileMaker WebDirect 

Yes 

FileMaker Server 

Yes 

FileMaker Cloud for AWS 

Yes 

FileMaker Data API 

Yes 

Custom Web Publishing 

Yes 

Runtime solution 

Yes 

Originated in 

FileMaker Pro 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.

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

Related topics 

Script steps reference (alphabetical list)

Script steps reference (category list)