Grid Views and Filters
- Mariano Martinez Melo
- Jun 20, 2023
- 1 min read
The navigability of grid views has been updated for some time now, so today, we will explore these features and combine them with working with filters.
In addition, here is a list of the operators and wildcards that are used when filtering:
Filter | Description | Example |
Value | Same as the value you write | Contoso will show "Contoso" |
!Value | Is not equal to the value that is written | !Contoso will display all values except "Contoso" |
StartValue..EndValue | Search from start to end value | 1..10 Search all values from 1 to 10. In a string, for example, A..C, it searches from A to C passing through B, Ba, Bc ... etc, but without reaching Ca. |
..Value o <Value | Less than and equal to the value | ..10 Search any value less than or equal to 10, for example: "1", "1.99", "10" |
Value.. o >Value | Greater than and equal to the value | ..10 Search any value greater than or equal to 10, for example: "15", "21.99", "10" |
Value* | Starts with the specified value | C* Finds "Contoso", "Claudia" or "Coco bongo" |
*Value | Ends with the specified value | *oso Finds "Contoso", "Famoso" y "Oso" |
*value* | Contains the specified value | *os* Finds "Contoso" "Dos" "Amoroso" "Oso" |
? | Une or more unknown characters | Cont?so Finds "Contoso" "Controso" |
Value1,Value2 | Match exactly with comma separated values | 1,2,3 finds "1", "2" y "3" but no "2.5" |
"" | Blank values | "" Finds everything that has no values |
Day(Value) | Date relative to session date | Day(0) Today, Day(1) Tomorrow, Day(-1) Yesterday |
DayRange(DayFrom, DaysTo) | Date range in relation to the date of the session. | DayRange(-30,30) Searches from 30 days before the session date and 30 days after the session date. |
GreaterThanDate(Days) | Dates after the specified date | GreaterThanDate(10): greater that 10 days after today |
LessThanDate(days) | Dates before the specified date | LessThanDate(10): Less than 10 days before today |
I also leave the Docs link for more filters to work!
Comentários