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.

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	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