This usefulness of a control like this will be beyind measure. However, in my opinion the current UI is not intuitive. Even as a technical person I am having trouble figuring out how the ANDs and ORs relate to each and which things are being grouped together. If i can't figure it out, there is no way my users will be able to figure it out.
I know its still early, but here is some general feedback:
1) It would be more intuitive if the filter clauses where structured like a familiar SQL where clause. Currently, the first thing is the filter is a AND or OR. That doesn't make intuitive sense. What am I ANDing together? Nothing yet.
What if I only need 1 filter? (OrderID = 123).
The first thing in the filter should be an actual filter (ie. OrderID=123), THEN have the ability to add AND or OR concatenators.
2) The drop down context menu on the "+" button needs some clarification. After trial and error, I was able to figure out that the first option adds a filter clause to the chain and the second option adds a AND/OR concatenator. But it is not intuitive.
3) Add some type of grouping visual indicator. I suggest the familiar parantheses as people understand that this groups things together and they can tell which items are being concatenated. I think you could also accomplisht this with indentation, which appears to be the direction you are headed, but currently, it seems like you can only indent one direction.
Consider this difference:
WHERE
(OrderID > 100 AND OrderID < 200)
OR
(Country = "France")
versus:
WHERE
(OrderID > 100 AND (OrderID < 200 OR Country = "France"))
There is a difference, but I couldn't figure out how to represent these using the UI.
4) Consider adding a text representation of the resulting WHERE clause so the user can see what they aare building to confirm it.
I know its still early, but here is some general feedback:
1) It would be more intuitive if the filter clauses where structured like a familiar SQL where clause. Currently, the first thing is the filter is a AND or OR. That doesn't make intuitive sense. What am I ANDing together? Nothing yet.
What if I only need 1 filter? (OrderID = 123).
The first thing in the filter should be an actual filter (ie. OrderID=123), THEN have the ability to add AND or OR concatenators.
2) The drop down context menu on the "+" button needs some clarification. After trial and error, I was able to figure out that the first option adds a filter clause to the chain and the second option adds a AND/OR concatenator. But it is not intuitive.
3) Add some type of grouping visual indicator. I suggest the familiar parantheses as people understand that this groups things together and they can tell which items are being concatenated. I think you could also accomplisht this with indentation, which appears to be the direction you are headed, but currently, it seems like you can only indent one direction.
Consider this difference:
WHERE
(OrderID > 100 AND OrderID < 200)
OR
(Country = "France")
versus:
WHERE
(OrderID > 100 AND (OrderID < 200 OR Country = "France"))
There is a difference, but I couldn't figure out how to represent these using the UI.
4) Consider adding a text representation of the resulting WHERE clause so the user can see what they aare building to confirm it.