'Contains' & 'Not contains'

How does contains & not contains filter work

They contain filter is used when you have any specific word contained in a phrase.

Example: I want to filter the products which contain apples.

Consider that the store contains many products like Sony headphones, Bose headphones, Sony tv, Apple charger, Apple iPhone 5, Apple iPhone 6, Apple iPhone 7, Apple Mac computer, Apple headphones, Apple mouse, SanDisk music player, SanDisk Pen drive, Seagate hard disk, HP laptop, etc.

When the contains a filter for the product Apple is applied, the report will pull only the Apple products since all the products have the name Apple in common, i.e., Apple iPhone 5, Apple iPhone 6, Apple iPhone 7, Apple Mac computer, apple headphones, and Apple mouse.

Similarly, when not contains a filter for the product Apple is applied, the report will pull only the Non-Apple products, i.e. Sony Headphones, Bose Headphones, Sony TV, SanDisk music player, SanDisk Pen drive, Seagate Hard disk, HP Laptop.

Last updated