Quote Originally Posted by Hulan View Post
AND OR queries are hard to represent easily through a GUI due to order of operation ambiguity. Is the query [int > 10 AND mnd > 5 OR macc > 12] actually [(int > 10 AND mnd > 5) OR macc > 12] or is it [int > 10 AND (mnd > 5 OR macc > 12)]?

That being said, this would indeed be very useful. Either give us order of operation operators or force a simple front to back precedence and I would be behind this suggestion 100%.
Haha tricky.
I code some too so I know exactly what you are talking about.
Since you don't want to make it too complex for the end users, it would probably be best to leave it as all AND or all OR. Just have a radio button selection between AND and OR. Then insert the option into the look up code.
I'm better at SQL/VB than Java, but the end result would be something like...

useroption = optionbox.selectedvalue
int > 10 [useroption] mnd > 5 [useroption] macc > 12