Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

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👇.

Quick Filter

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👇.

The quick filters are automatically converted into an advanced filter. Remember that you can upgrade the quick filter to an advanced filter, but the inverse process is not allowed.

Advanced Filter

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?