Filter logic breakdown
This reference explains the filter logic breakdown, detailing how various conditions are combined to refine datasets effectively.
The below example provides the filter logic breakdown:
Forced Filter (Non-Nested Filter): This represents a mandatory filter condition applied to the dataset. It ensures that only products meeting specific criteria are included in the filtered results.
Base Products: This criterion encompasses the foundational products within the dataset, serving as the starting point for further filtering.
Food Items:
Fruits: Within the category of food items, this criterion narrows down the selection to specifically include fruits.
Fresh Stocks: Another condition within the food items category, ensuring that only products with fresh stocks are included.
Price 100: This condition specifies that the products selected must have a price of $100.
Vegetables:
Price 200: Products meeting this criterion must have a price of $200.
Example Filter Logic:
The filter logic combines various conditions to refine the dataset effectively:
Forced Filter (AND) Base Products (AND) ( (Food Items (AND) Fruits (AND) Fresh Stocks (AND) Price 100 ) OR (Food Items (AND) Vegetables (AND) Price 200))
This logic ensures that the selected products are either fruits with fresh stocks and a price of $100 or vegetables with a price of $200. By applying this filter logic, users can precisely target and retrieve the desired subset of data from the dataset, tailored to their specific criteria and requirements