Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

🔍 'Contains' & 'Not Contains' Filters

Easily include or exclude records in your reports with these two powerful filter types.


✨ Contains Filter

Use the 'Contains' filter in Reports when you want to view only the records or fields that include a specific word or phrase.

Example:
Your store sells a wide range of apparel — Nike T-shirts, Adidas sneakers, Puma hoodies, Levi’s jeans, H&M jackets, Zara shirts, Uniqlo trousers, and more.

If you want to filter products that contain the word "NIKE", simply apply the Contains filter for NIKE.

Contains Filter

The report will now only show NIKE products such as NIKE SWOOSH PRO FLAT PEAK CAP, NIKE CRACKLE PRINT TEE, and NIKE RUNNING SHOES — all of which have the word “NIKE” in their name.


🚫 Not Contains Filter

Use the 'Not Contains' filter in Reports when you want to exclude any record or field that contains a specific word or phrase.

Example:
Your store sells a wide range of apparel — Nike T-shirts, Adidas sneakers, Puma hoodies, Levi’s jeans, H&M jackets, Zara shirts, Uniqlo trousers, and more.

If you apply the Not Contains filter for “NIKE”, your report will exclude all NIKE products and instead display non-NIKE items such as Adidas Ultraboost Sneakers, Puma Sport Hoodie, Levi’s 511 Slim Jeans, Zara Cotton Shirt, and H&M Denim Jacket.

Not Contains Filter

The Not Contains filter helps you instantly narrow your data by excluding specific keywords — perfect for focusing on other brands, collections, or product types without manual sorting.


💡 Tip: You can add multiple filter values with the Contains and Not Contains conditions to refine your reports even further.


➡️ Next Filter: ⚖️ Is & Is Not Filters