Query conditions

Use query conditions to limit the records to retrieve.

Select a preset condition or build a custom condition:

• The first condition must use a date field.
• When there are too many records to load at once, a warning will appear. Click the warning to load additional records. Click Cancel to cancel loading records.
• Hint: To query for an exact value, set the date (first) condition to ALL, and the second condition to the value to search. This query is case sensitive. For a case-insensitive query, set the date condition to a date range.

Columns

Select the columns to display.

• Click the column in Available to add it to the list.
• Click the column in Selected to remove it from the list.
• Check Repeatable columns to include columns inside Table and Repeatable controls in the Available list.

See the list of system columns.

Filter

Once records have been retrieved, they can be rapidly filtered.

Click Filter to open the filter options:

Only records that have been retrieved can be filtered and sorted.

Sort

Click Sort to sort  by a column.

Click again to sort descending.

Click a third time to remove the sort.

Click a second column to add a second level sort.

View

Click Save to save the selected query conditions and columns as a View.