Skip to main content

Using XQL Filters in Channels

XQL filters in Xyxle let you define advanced product selections using custom queries. Ideal for precise filtering. This guide shows you how.

Updated over a week ago

Key Features of XQL Filters

  • Advanced Query Input: Accessed via the “XQL” button, you get a text box where you can manually write complex filter rules.

  • Attribute Autocomplete: Just type a letter, and the system suggests matching attributes.

  • Operator Suggestions: Logical and comparison operators like =, !=, IN, AND, etc., are automatically suggested.

  • Value Suggestions: Once you've selected an attribute and operator, the system helps you choose from available values.

  • Logical Chaining: Combine conditions using AND or OR.

  • Save & Reuse Filters: You can save your custom filters for future use or quick adjustments.

How It Works: Step-by-Step

  1. Activate XQL Mode
    Click the XQL button. A text box will appear where you can start building your filter.

  2. Select an Attribute
    Start typing the attribute (e.g., “G”) and a dropdown will show available options like:

    • M017: GTIN

    • M029: Allergens

    • M034: Diet type code

    • …plus more like Modified Date, Product Groups, Type.

3. Choose an Operator
After selecting an attribute, hit the spacebar. A dropdown will appear with comparison operators:

  • =, !=, >, <, <=, >=, IN, NOT IN, ~

4. Pick a Value
Hit space again and choose from the list of valid values (these depend on the attribute you selected).

5. Add Logical Operators (if needed)
To combine conditions, hit space one more time and pick:

  • AND, OR
    Then continue building the next condition from step 2.

6. Apply the Filter
When your query is complete, click the Filter button to apply it. Your items will now be filtered based on the rule you defined.

7. Save Your Filter (Optional)
If you want to reuse this filter, click the Save filter icon. Name your filter in the dialog that appears. You can now quickly reapply or modify it later without rebuilding it from scratch.

Practical Tips

  • Start Simple: Don’t overcomplicate your first query. Test a single condition to see how it works, then add more.

  • Use Saved Filters for Repetitive Tasks: If you frequently apply the same filter, save it. It’ll save you time.

  • Double-Check Logical Chains: Combining conditions with AND and OR? Read it back like a sentence to make sure the logic holds.

  • Know Your Attributes: Familiarize yourself with the most common ones in your workflow (like GTIN, Allergens, Storage Instructions) so you can work faster.

Summary

XQL filters in Channels give you powerful control over which items appear in your exports. You can manually build filter queries by selecting attributes, operators, values, and logical connectors. The system helps you along the way with dropdown suggestions, making it easier to write correct and effective filters. Once you're happy with a filter, you can save it for reuse.

For more help with XQL syntax or attribute meanings, check the in-app documentation or reach out to your Xyxle support team.

Did this answer your question?