With advanced filter you can filter data based on any rule. This is a simplified version of database quering without you having to write any SQL query. You will just use UI dropdown and filter data based on your conditions.

Example 1

I want to filter all products under Category “Desktops“

Example 2:

I want to filter products that have quantity less than 10

Example 3:

I want to filter products that have quantity greater than or equal to 100, and only category belongs to desktops, and manufacturer belongs to Apple or Sony