Get(SortState)
Purpose 
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.
 •
For information on how functions evaluate differently on the host versus the client, search the FileMaker Knowledge Base available at http://help.filemaker.com.
Examples 
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
Was this topic helpful? Send feedback.