22.2 Basic and Advanced Filtering
| Type | Options | Example |
|---|---|---|
| Basic filtering | Tick values; search box; Select all; Require single selection | City is Pune, Solapur |
| Advanced filtering | Text: contains, does not contain, starts with, does not start with, is, is not, is blank, is not blank, is empty, is not empty. Numbers: is less than, is greater than or equal to …. Two conditions with And/Or. Click Apply filter | Product Name contains "Misal" Or contains "Poha" |
Ravindra Bagale's Tip
Ek common chuk mhanje using Basic filtering to untick "(Blank)" and forgetting that the filter now hides new values that arrive later. For rules like "City is not blank", use Advanced filtering, which keeps working as new values appear. He exam aani interview doghansathi important aahe.