Skip to content
P2Lab Filter

Your first filter

This walkthrough builds a single condition on the product list. It takes about a minute and teaches the pattern you will use everywhere else.

1. Open the bar

Section titled “1. Open the bar”

Go to Catalogues → Products. Click the bar that reads Click to add a condition…. A list of fields opens.

2. Pick a field

Section titled “2. Pick a field”

Start typing to narrow the list — for example type stock. The list filters as you type. Click Stock.

Fields marked with a small arrow are relations: clicking them drills into the related record’s fields instead of choosing a value. You can read more in Fields and relations.

3. Choose an operator

Section titled “3. Choose an operator”

After the field, the bar offers an operator — the comparison to make. For a number field like Stock you will see options such as between, at least, at most and is. Pick at least.

Some fields skip this step automatically because they have only one sensible operator (a Yes/No field is always is). You can also turn the step off for every field in the Options.

4. Enter a value

Section titled “4. Enter a value”

Now type the value — for Stock at least, enter a number such as 10. Press Enter.

The product list narrows to products with stock of at least 10, and the finished condition stays in the bar as a pill:

Stock · at least · 10

5. Add another condition

Section titled “5. Add another condition”

Click the empty part of the bar again and repeat. A second condition — say Active is Yes — narrows the list further. Conditions combine: a product must match all of them.

By default each completed condition applies immediately. If you prefer to collect several first and apply them together with Enter or the search button, switch the apply mode in the Options.

6. Edit or remove

Section titled “6. Edit or remove”
  • Edit — click any part of a pill (the field, operator or value) to reopen it and change it.
  • Remove one — hover the pill and click its ×.
  • Clear everything — click Clear all conditions at the right edge of the bar.

Where to go next

Section titled “Where to go next”

You now know the core loop. From here: