I am trying to create a retail search solution that lets users specify their requirements dynamically.
Ie a user might be searching for a tv, one requirement is that type=smart, and then either its "size>32 and price<3000" or "size>=48 and price=5000"
So I'm having a real problem structuring this in a dynamic way. Thus far i have the following tables:
I'm able to specify what operation happens within each grouping, and am currently limited to joining the relevant groups with an "and" clause, But I really want an eloquent way to specify the operations between the groups, especially if I want to nest them.
Hopefully you can understand what I'm trying to do from the examples. Any help / scolding would be appreciated