Overview

ProductSync provides powerful filtering capabilities that go beyond simple text search. You can filter by related data, calculate metrics on the fly, use complex AND/OR logic, and save your favorite filters as quick-access tabs.

This guide covers the advanced filtering features available in the Advanced Filter Editor and Direct Filter Mode.

Creating a Simple Filter

You can build structured filters using the visual editor to select specific fields, operators, and values.

[navigate:/products|Open Products|shopping-cart]

1. Click the **Advanced Editor** button (slider icon) next to the search bar.
2. Click **Add Condition** to start a new filter rule.
3. Click the **Select Field** button.
4. Choose the field you want to filter by (e.g., **Name** or **Price**).
5. Select an operator (e.g., **equals**, **contains**, **greater than**) and enter your value.
6. Click **Apply** to see the results.

**Tip:** You can edit an existing filter by clicking on the filter chip in the search bar.

You can filter records based on fields in related entities (e.g., find Products where the Brand name contains “Nike”).

1. Open the **Advanced Filter Editor**.
2. Click **Add Condition** and open the **Select Field** menu.
3. Navigate through the relation tree (e.g., click **Brand**).
4. Select the specific field from the related entity (e.g., **Name**).
5. Set your operator (e.g., **contains**) and value (e.g., "Nike").
6. Click **Apply**.

Filtering by Count or Sum (Aggregations)

You can filter records based on calculated metrics, such as the number of orders or the total value of items. This uses the Direct Filter Mode.

[navigate:/customers|Open Customers|users]

1. Double-click the **Filter Bar** to activate Direct Mode.
2. Type your aggregation query using the `@` syntax:
    - To count related items: `@count:orders > 5`
3. Press **Enter** to apply.

**Note:** These aggregation filters are currently only available via Direct Mode and cannot be built using the visual editor.

Filtering by Date Range

For date fields, ProductSync provides a specialized range picker.

1. In the **Advanced Filter Editor**, add a condition and select a **Date** field (e.g., **Created At**).
2. The value editor will show **From** and **To** inputs.
3. Select a start date in the **From** field.
4. Select an end date in the **To** field.
5. Click **Apply** to see records created within that range.

**Tip:** Leave one of the fields empty to create an open-ended range (e.g., "Created after Jan 1st").

Complex Logic (AND/OR Groups)

You can combine multiple conditions using nested AND/OR logic to create precise queries.

1. Open the **Advanced Filter Editor** and add your initial conditions.
2. Click the **Add OR** button to create a new logical group.
3. Drag existing conditions into the new group using the drag handle (dotted icon).
4. Or, click **Add Condition** inside the group to create new rules.
5. Toggle between **AND** and **OR** by clicking the group operator.
6. Click **Apply**.

Selecting Values from a List (Lookups)

For fields with a fixed set of options (like Status) or references to other entities (like Category), you can select values from a list.

1. Add a condition for an **Enum** or **Relation** field (e.g., **Status** or **Category**).
2. Click the value input field.
3. Type to search for a value (e.g., "Active" or "Electronics").
4. Select the item from the dropdown list.
5. You can select multiple items to create an "IN" filter (e.g., Status is Active OR Pending).
6. Click **Apply**.

Saving Filters as Tabs

Save your frequently used filters as tabs for one-click access.

1. Apply any filter using the search bar or advanced editor.
2. Click the **Save filter** icon (floppy disk) in the filter bar.
3. Enter a **Name** for your view (e.g., "Active High-Value Products").
4. Check the **Show as tabs** option.
5. Click **Save**.

Your new tab will appear above the grid. You can switch between views instantly.

Monitoring Data Quality

Use the dedicated Data Quality tools to find records that are missing required information.

[navigate:/dataQuality|Open Data Quality|activity]

1. Go to the **Data Quality** dashboard.
2. Use the **Filter by Related Entity** dropdown to choose the type of record (e.g., **Products**).
3. Use the **Validation Rules** dropdown to select a specific issue (e.g., **Missing EAN**).
4. The grid will update to show only the records that violate that rule.