Versions Compared

Old Version 5

changes.mady.by.user Ahmad Zahedi

Saved on

compared with

New Version 6

changes.mady.by.user Ahmad Zahedi

Saved on

Key

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

...

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

Datagrid Sorting

Include Page
Data Grid Sorting
Data Grid Sorting

Views

The MAGNET Data Grid allows for users to save their filters or other changed that they have made to the Data Grid, to make pulling back up previous filters or reports simple. In MAGNET, these saved Data Grid filters are called “Views”.

...