I have a basic wix store. It uses the Products and Collections store tables. I am trying to figure out how to filter a dynamic dataset to include only products that belong to a collection. The collection is provided as a query string, so it should be loaded dynamically. The products and collections are many-to-many.
Example: If I want my dataset to be populated with all "clearance" products, the url would look like /collection/clearance, and the product dataset would contain only products tagged with the clearance collection; of /collection/fuzzy would show only products that were in the fuzzy collection.
There seems to be no relational data in these pre-built tables.