top of page
Search

Grid Views and Filters

  • Writer: Mariano Martinez Melo
    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


bottom of page