Hi
If I have mutiple filters in single query and I haven’t braced them in [[]], then will it still consider that part of query or it simply ignores it?
e.g
select * from product
where {{product_category}} AND {{product_price}};
So, if I have kep “Required” toggle button off for “product_price” filter and I also don’t brace it around square brackets ([[{{product_price}}]]), then how would my query look like?
- select * from product
where product_category = ‘cosmetic’ AND product_price = ;
OR - select * from product
where product_category = ‘cosmetic’;