Question:
What are the Operators to use with the Advanced Filter function in PromoMats?
Answer:
The following Operators are available for Advanced mode on faceted filters:
- In
The in operator returns results that include at least one of the filter values in the field.
Example Filter: Product in CholeCap, Nyaxa
Match: Product = CholeCap, Nyaxa
Match: Product = CholeCap, Nyaxa, WonderDrug
Match: Product = Nyaxa - Equals
The equals operator returns results that include all of the filter values in the field. For multi-select fields, the field on the matching document or object may contain additional values.
Example Filter: Product equals CholeCap, Nyaxa
Match: Product = CholeCap, Nyaxa
Match: Product = CholeCap, Nyaxa, WonderDrug
No Match: Product = Nyaxa - Is Not Equal To
The is not equal to operator returns results that do not include any of the filter values in the field.
Example Filter: Country is not equal to Japan
No Match: Country = United States, Japan
Match: Country = (undefined)
Match: Country = United States
Example Filter: Country is not equal to Canada, United States
No Match: Country = United States, Canada, Japan
No Match: Country = United States
Match: Country = (undefined)
Match: Country = Japan - Is Blank
The is blank operator returns results that have no selected value in the filter field. In Basic mode, this appears as (undefined). - Is Not Blank
The is not blank operator returns results that have any value selected in the filter field.
Related Documentation:
Vault Help Documentation: Operators for Advanced Filters
Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.