Reference > Script steps reference > Found Sets script steps > Show Omitted Only

Show Omitted Only

Finds the records not in the current found set.

Options

None.

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

Use this script step in Browse mode or Preview mode. If you perform this script step in Find mode or Layout mode, FileMaker Pro Advanced switches to Browse mode after the records have been found.

Example 1

Shows all omitted records.

Show Custom Dialog ["Show omitted records?"]
If [Get ( LastMessageChoice ) = 1]
	Show Omitted Only
End If

Example 2

Demonstrates that using the Find Matching Records script step instead of Show Omitted Only can be a simpler way to create a found set of only the current record.

#With Show Omitted Only, multiple steps are necessary
#to create a new found set, omit the current record,
#and show only the omitted record.

Show All Records
Omit Record
Show Omitted Only

#A single Find Matching Records script step can perform the same task
#when a field with unique values, such as an Invoice ID field, is specified.

Find Matching Records [Replace; Invoices::Invoice ID]