Using Advanced Filters in Pipe17

Some tables in Pipe17 support advanced filtering in addition to the surface-level quick filters. This article will cover some more advanced queries we can do with advanced filters.

For this article, we will be working with the advanced filter on the products table page.

Filtering for bundle products containing a specified bundle SKU

The EMOCK-BNDL product above has two bundle items, EMOCK-TEAPOT and EMOCK-TEACUP. Using advanced filters, let's search for all products where EMOCK-TEAPOT is a bundle item. 

1. The filter field is "Bundle Items SKU."
2. The value field is "EMOCK-TEAPOT."
3. Since this field is an array of strings, select "Contains" as the operator. This will tell the query to match products where EMOCK-TEAPOT is one of the SKUs in its bundle items.

Filtering for all products with mapped SKUs

Some products can have channel SKUs defined for specific integrations to map the Pipe17 SKU to the equivalent SKU in the target integration if they are different.

Let's search for all products that have a channel SKU defined. To do this, we can set up the filter as the following:

1. Set the filter field to "Published SKU."
2. Since we only care about the existence of a value, let's select "regex" as the operator and "." as the value. Since a period represents any character, the existence of any character, it will return all products with at least one published SKU.

Any vs. All

With the standard table filters, the filters are restrictive, so the query results must pass all of the specified filters. However, in some cases you may be interested in entities that pass any of the filter conditions. The example below will return products that do not track inventory OR are taxable. Simply change the filter condition from "All" to "Any."