Apply one filter
On grids columns, you can filter the data to display.
To do so:
- CLick on the button on the top of the column
- Select the type of filter to apply:
- For List and Yes/No fields, go on the next step
- For Text fields:
- Contains
- Is equal
- Is not equal
- Is null
- Is not null
- For Dates and Number fields:
- Is between
- Is equal
- Is not equal
- Is after
- Is strictly after
- Is before
- Is strictly before
- Enter filter value
- For List fields: select one or more values
- For Dates and Number fields: select True, False or Not set
- Click on APPLY
- Your grid is filtered
Apply several filters
To apply several filters on your grid, two options are possible:
- Repeat instructions on section Apply one filter on all columns to filter
- Use the multiples filters functionnality
For the second option, follow steps below:
- Click on the icon on the top right of the grid
- Select the first field to filter and select its value, same way presented on section Apply one filter
- Click on VALIDATE to add the filter
- Add all other filters and click on VALIDATE on the bottom of the window
- Your grid is filtered:
- On the top, next to All Participants, you have the number of lines on the grid
- An orange dot on the icon indicate the number of filters applied on the grid
Advanced filters and personalised tab
Advanced filters
On all inwink grids, when you click on the icon to access filters, you have an Advanced tab.
This tab allows you to add filters with options AND and OR.
Example: the grid must show all participants who are registered AND who have authorized networking AND whose badge has been printed on site OR if present in person is equal to true.
Personalized tab
On participants grid, when you click on the icon to access filters, a tab Personalized is available.
This tab allows you to filter participants by their presence at the event: it is interesting to use this filter to create a view to pin on a dashboard.