Filtering records

Updated in 2024

Filtering allows you to display only those records that meet specific criteria and exclude the rest of them.

Filtering is especially useful when you’re working with large number of records and at least approximately know which kind of records you want to find. For example, you may want to display all computers with a particular configuration, such as Windows 10 Pro, CPU Speed less than 2.1 GHz, and HDD free space less than 100 MB.

These filters are available:

• Quick filter: A simple, quick way to filter the data view on the fly, using the columns (record fields) that are shown in the grid. The quick filter applies to the records that have already been retrieved from the database.

• Advanced filter: An advanced, permanent solution for retrieving from the database only the records that meet the filtering criteria you define. The advanced filter allows filtering the grid by any fields, including both visible and hidden ones. This filter can reduce the number of retrieved records, making it preferable when working with a large dataset or a slow connection.

NOTE: If you apply a new filter without first removing the previous filter, the new filtering conditions and the previous filtering conditions add up.