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 version 

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.

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