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.
![](https://www.huntbee.com/resources/wp-content/uploads/2021/08/screenshot-opencart-demo.huntbee.com-2021.08.07-21_59_47-1024x500.png)
Example 1:
Search Orders having the Product “One Shoulder Satin Slip Dress” and order placed between 1st April 2021 and 30th July 2021
![](https://www.huntbee.com/resources/wp-content/uploads/2021/08/screenshot-opencart-demo.huntbee.com-2021.08.07-22_07_09-1024x649.png)