Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Located above the Data Grid to the right, there Data Grid Actions, as highlighted in the image below, allow for the creation of new applications, exporting of the Datagrid Data Grid and managing the columns currently shown in the Data Grid.

...

Operator

Description

Example

THRU

Used to search for the data range.​

12/1/2025 THRU 12/31/2025​

AND

Searches for two terms in the column.​

Building AND Demolition​

TODAY

Filters to today’s date.

Note

This only works in date fields.​

TODAY​

<

Used to find the values that are less than the value entered.​

< 100

>

Used to find the values that are greater than the value entered.​

> 500

<=

Used to find the values that are less than OR EQUAL TO the value entered.​

<= 500

>=

Used to find the values that are greater than OR EQUAL TO the value entered.​

>= 10000

%

Used as a wildcard character.​

Fes%val

IS BLANK

Returns all the rows where this column is empty.​

IS BLANK

NOT BLANK

Returns all the rows where this column is not empty.​

NOT BLANK

IS

Used to search for exact matches. Helpful for finding specific statuses.

Info

This can be useful for limiting to specific statuses that have similar labels, such as “Active” and “Inactive”

IS Active

...

Data Grid Sorting

Include Page
Data Grid Sorting
Data Grid Sorting

...