Reference > Functions reference > Get functions > Get(SortState)
 

Get(SortState)

Returns a value representing the current sort state.

Format 

Get(SortState)

Parameters 

None

Data type returned 

number

Originated in 

FileMaker Pro 6.0 or earlier

Description 

Returns:

0 if the records in the active table are not sorted

1 if the records in the active table are sorted

2 if the records in the active table are partially sorted (semi-sorted)

Each window has its own sort state.

Notes 

When records are imported from another file to a previously found and sorted set, the records in a sorted set may exist in a semi-sorted state. To include the imported records in the sort order, sort the found set after importing.

If you specify the context for the current calculation, this function will be evaluated based on that context; otherwise, it will be evaluated based on the context of the current window.

Example 1 

Returns 1 when the records in the active table are sorted.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas