I'm building a "query builder". User selects columns, then "conditions" which is the "where" clause.
Our users aren't technical.
1. My manager says to make it look like what TFS does.... AND, OR and then maybe parenthesis to see what conditions should be in parenthesis and grouped together.
This is TFS query builder
2. I was researching this and came across this Query Builder Example - Demo
Please look at the "Condition" section. It has "all", "any", "none" and "not all". No And/Or and parenthesis and grouping the AND/OR together.
I want to do the "all", "any", none" and "not all". Much simpler than AND/Or and parenthesis... too complicated.
How would you guys do it? how can I explain this to my manager that "all", "any", "none" and "not all" is simpler? how can I convince him? Other examples I can look at?