pftp | pftp repository
kandi X-RAY | pftp Summary
kandi X-RAY | pftp Summary
pftp repository
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of pftp
pftp Key Features
pftp Examples and Code Snippets
Community Discussions
Trending Discussions on pftp
QUESTION
I'm displaying a list of product filters.
Product filters are only displayed if they are applicable to the products contained within a chosen category.
I want to expand that further so once a filter has been activated, the non-applicable filters are not outputted.
So from the data sample below in products_filters_to_products:
- Once Orange has been selected as a Colour
- Only Small from Size should be made available
Query so far returns applicable filter categories, filters belonging to those filter categories and products that they apply to.
Tables and query so far shown below.
Tables
...ANSWER
Answered 2020-Jan-10 at 18:35You want to show all still matching filter values for filter category 2 (Size), when filter category 1 (Color) already has been set to a value (3 = Orange).
In order to find them, we'd look up all products matching category/value 1(Color)/3(Orange). This is only product 1. And the only filter value for product 1 and filter category 2(Size) is value 4(Small).
Let's make the scenario more complex: Let there be four filter categories: 1, 2, 3, and 4. For filter category 2 the value 22 has been chosen and for filter category 4 the value 44. Now, which values are available for the other filter categories (1 and 3)?
First we must get all item IDs that match both 2/22 and 4/44. This is more complex than just looking up one filter. The typical way of dealing with this is an aggregation:
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install pftp
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page