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

Example 1:

Search Orders having the Product “One Shoulder Satin Slip Dress” and order placed between 1st April 2021 and 30th July 2021