User Grid - Data Filtering
Filter User Grid records with Quick Filters by field type or the Advanced Filter Query Builder.
GridMate provides two methods for filtering the data: The Advanced Filter allows you to create more complex and intricate filters, while the Quick Filter provides an easy way to explore the grid without delving deeper into the conditions.
Quick Filter
GridMate provides flexible Quick Filter tools similar to the one provided by Salesforce standard UI. The filter is dynamic based on the field type:
Lookup Picker for lookup fields.
Range for dates, date times, currencies, percentages and other number fields.
Multiple Choice for PickList and Multi-Picklist fields.
Radio Button for checkbox fields.
Multiple Entries for text fields.
The video below is a step-by-step tutorial to learn how to use the Quick Filtering👇.
Advanced Filter
GridMate offers flexible and powerful Query Builder. Using this tool, the end user will be able to build advanced filters including:
Simple Condition : a basic condition to apply on a single field using an operator (<, >, =,...) and optionally a value to compare with.
Complex Condition: an OR/AND junction that involves multiple single or complex conditions. With this formalism, we can express any logical condition.
Cross Filters: a condition to check the existence or not of a child record. A Cross Filter could also be expressed using simple condition to filter the child records.
The video below is a step-by-step tutorial to learn how to use the Advanced Filtering👇.
Behind the scenes, the Query Builder produces a JSON like filter used by GridMate components. Below is the produced configuration for the tutorial above.
Next steps
Last updated
Was this helpful?