Filtering and sorting through addons

Osman

I'm creating a price comparison site and as such my product prices, specs and other information are all held in separate tables. This means that I can't add a sort by price high to low or anything like that nor can I add filters so users can filter for the brands which they want to see.

Michael Udinski

Hi @Osman - I'd probably rethink your parent query or take advantage of Joins/Evals to bring this data to the parent-level. Addons are a second pass at the query, so fundamentally they won't be able to sort a parent query.

Osman

Thank you, @Michael Udinski. I'm not too sure though what I should be doing for the joins and evals. I can join the tables but not sure what conditionals I should be using and then when sorting as 1 product has multiple prices I only want to select the lowest price of these and filter on that basis.