Data Grid Searching
- Ahmad Zahedi
Above each column in the Data Grid, there will be a text field that allows for the searching or limiting of data within the Data Grid.
Each field supports “auto-suggest” functionality, which will suggest options to you as you begin to type, additionally, the MAGNET Data Grid supports many data filters which give the user complete control over the data they are viewing or reporting on.
Data Grid filters
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. 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. This can be useful for limiting to specific statuses that have similar labels, such as “Active” and “Inactive”. | IS Active |
before (Added in v6.4.7) | Used to search dates before a specific interval. This only works in date fields. |
|