User interface ideas
-
:thumbsup:
Matthew Faithfull wrote:
At all stages as the expression is being built show the user the query text. The slightly intelligent ones will soon spot how it works. Allow them to bypass much of the UI by simply entering a query directly, not by overwriting the displayed partial one but in another parallel edit control. This is where validation becomes a major issue but it can be done. Only if the directly entered query passes validation should they be given the option to use it to replace the built query.
On the level of UI design, you, and I, are, evidently, somewhat compatible :) The challenge in your "parallel entry mode" model is, I think, validation of the user-entered query in standard boolean expressions (or whatever format) text. imho, unless you want to make a heroic effort, this is a slightly binary choice: if the user entered, in text-mode, a very complex nested filter, synchronizing the visual presentation of the GUI-mode filter facility with the text expression could be daunting. What if the user enters, in a TextBox: Contains "AB" && (! Contains "BC") || Contains "BC" || "CD" && (! BeginsWith("AB")) ... keep on going ... I'd solve this in a kind of "Alexander cuts Gordian Knot" style, by simply having the visual-mode facility "hidden" when the user decides to edit the contents in text-mode facility. As I said to OriginalGriff, I wish CP had a UI/UX forum for discussion of these kinds of ideas. yours, Bill
~ “This isn't right; this isn't even wrong." Wolfgang Pauli, commenting on a physics paper submitted for a journal
I agree. If the user is going to enter the query in textual expression form they probably don't need it represented in another form by the GUI. The graphical builder can close/grey out at that point. The good thing about the dual approach is discoverability. The user can begin constructing a query with the slow but simple GUI, see how the textual Boolean expression works with &&, ||, ! and the various functions and then cut to exactly what they want by typing it in. Most users will initially ignore the code string being built up for them but will absorb subconsciously and quite effortlessly what &&, || and ! mean. When they later see a Boolean expression they'll understand what it means and they probably won't even know how. It will just be obvious. :)
"The secret of happiness is freedom, and the secret of freedom, courage." Thucydides (B.C. 460-400)
-
That's pretty close to what I was originally thinking with the "tree" idea. I understand it, I'm just not sure the indentation makes it that obvious to a "normal" user.
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
I while ago I sat down and tried to think out a better UI for a "general" filter, it contained expandable brackets instead of just indentations, but I didn't go any further.
Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln
-
Anybody found a "nice" way to get users to create and use complex filters? I have simple filters and they work well: A drop down for Type: Name, and four different classes. If it's the name, then they get a drop down to select "Contains", "Starts with", "Ends with", "Does not contain" and so forth together with a text box. If it's one of three classes, you get a drop down for "Includes all of", "Includes any of", "Includes none of", and "Does not include", together with a dropdown list of valid values. The final class gets just "Is in" and "Is not in" and a dropdown list. All grouped up in a simple control that I feed a list, and it does the filtering. No problems. Now I've had a request for making it more complex:
"Name Contains 'ABCD' AND Class Includes any off <list> OR Otherclass Is not in <AnotherList>"
for example. Coding wise this is a doodle - that's partly why I made a filter control in the first place. It's trying to work out how to present it to an average user so it's easy to create, understand and edit that's giving me problems. I was thinking of a tree of some kind so it's obvious if the example above is
"A AND (B OR C)"
or
"(A AND B) OR C"
but I'm not sure a tree is that obvious to the average joe... Anyone seen a good way? And I'm not after code, just the presentation ideas - so this isn't a programming question! :laugh:
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
OriginalGriff wrote:
Anybody found a "nice" way to get users to create and use complex filters?
Quite some, but "nice" is a very stretchable term. It's always a tradeoff between power and simplicity. The DevExpress filter is a "nice" one, in that sense; one can define a simple filter in the grid itself[^], or a complexer filter using an editor[^]. The complexer filter is all that the average user doesn't want; a column to denote "and/or", a column for the field-name to operate on, a column for the operator and a column for the value. Most home-made filters will act like the DevExpress-version; a grid that holds the same info. It's not recommended for novice users. It seems as if you do not only have filters, but also multiple datasources/tables to choose from. I've lost the bookmark, but there's a freeware QBE-editor available for .NET (similar to Active Query Builder[^]); works exactly like the Query-editor from Microsoft Access. I'd recommend that one as it's very easy to operate - simply hand them a manual for MS Access. If your audience isn't built from novices, I'd suggest putting a textbox in there and have the user type his/her filter. It's very effective, powerfull and easy - my favourite.
OriginalGriff wrote:
but I'm not sure a tree is that obvious to the average joe...
So, how does your average Joe muck around in his/her UI? I'm all in favor of keeping the Win3.11 UI, as it's familiar to most users - things always work in the same way. Then, when I look at the average Joe and his phone, I often wonder how they ever discovered that there's a function hidden in a particular screen.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[
-
Have a look at the DevExpress filter control[^]. You can make the filter as complex as you'd want to, while staying easy to use. Well, as easy as it gets when it can do "everything". It's not that quick to use though I have to say.
Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln
That looks about as easy and intuitive as you can get without a really complex GUI.
VS2010/Atmel Studio 6.1 ToDo Manager Extension You're about to exceed the limitations of my medication.
-
You linky is broky. Needs an l http://www.devexpress.com/Products/NET/Controls/ASP/Grid/filter_editor.xml[^] That's not a terrible UI but it lacks the editable query string I mentioned and it doesn't promote query or sub query reuse.
"The secret of happiness is freedom, and the secret of freedom, courage." Thucydides (B.C. 460-400)
Matthew Faithfull wrote:
You linky is broky
Oops, fixed.
Matthew Faithfull wrote:
That's not a terrible UI but it lacks the editable query string I mentioned and it doesn't promote query or sub query reuse.
No, but as Eddy writes, it's a tradeoff...
Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln
-
That looks about as easy and intuitive as you can get without a really complex GUI.
VS2010/Atmel Studio 6.1 ToDo Manager Extension You're about to exceed the limitations of my medication.
Yes, but as Eddy so well puts it, it's still not for the average Joe, you need the simple filter functions still. I've been thinking out "better" solutions to the problem, but they always miss out on something else instead. Usually space.
Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln
-
OriginalGriff wrote:
Anybody found a "nice" way to get users to create and use complex filters?
Quite some, but "nice" is a very stretchable term. It's always a tradeoff between power and simplicity. The DevExpress filter is a "nice" one, in that sense; one can define a simple filter in the grid itself[^], or a complexer filter using an editor[^]. The complexer filter is all that the average user doesn't want; a column to denote "and/or", a column for the field-name to operate on, a column for the operator and a column for the value. Most home-made filters will act like the DevExpress-version; a grid that holds the same info. It's not recommended for novice users. It seems as if you do not only have filters, but also multiple datasources/tables to choose from. I've lost the bookmark, but there's a freeware QBE-editor available for .NET (similar to Active Query Builder[^]); works exactly like the Query-editor from Microsoft Access. I'd recommend that one as it's very easy to operate - simply hand them a manual for MS Access. If your audience isn't built from novices, I'd suggest putting a textbox in there and have the user type his/her filter. It's very effective, powerfull and easy - my favourite.
OriginalGriff wrote:
but I'm not sure a tree is that obvious to the average joe...
So, how does your average Joe muck around in his/her UI? I'm all in favor of keeping the Win3.11 UI, as it's familiar to most users - things always work in the same way. Then, when I look at the average Joe and his phone, I often wonder how they ever discovered that there's a function hidden in a particular screen.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[
Eddy Vluggen wrote:
I often wonder how they ever discovered that there's a function hidden in a particular screen.
Their kids told them.
Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln
-
I while ago I sat down and tried to think out a better UI for a "general" filter, it contained expandable brackets instead of just indentations, but I didn't go any further.
Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln
Oooo! That's not bad - a single curly bracket on the LHS "pointing" at the grouping term...
/ A | / / And - | \\ / |Or - \ B
\
|
\ CNeed a bit of thinking about, but that could work. Not sure how you make it obvious how to add a grouping, but that could work...
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
-
Yes, but as Eddy so well puts it, it's still not for the average Joe, you need the simple filter functions still. I've been thinking out "better" solutions to the problem, but they always miss out on something else instead. Usually space.
Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln
I guess it all boils down to is what mentality of audience are you writing for? I once developed a test machine (shake and bake) for a US plant in Mexico and they told me to make the results of the test as simple as I could. I output everything to a mechanical meter and told the foreman that if the results where within a certain range it was acceptable anything outside the range wasn't, he asked to borrow a sharpie that I had in my pocket and drew lines on the meter and said if I hadn't done that they would not have been able to figure it out.
VS2010/Atmel Studio 6.1 ToDo Manager Extension You're about to exceed the limitations of my medication.
-
I guess it all boils down to is what mentality of audience are you writing for? I once developed a test machine (shake and bake) for a US plant in Mexico and they told me to make the results of the test as simple as I could. I output everything to a mechanical meter and told the foreman that if the results where within a certain range it was acceptable anything outside the range wasn't, he asked to borrow a sharpie that I had in my pocket and drew lines on the meter and said if I hadn't done that they would not have been able to figure it out.
VS2010/Atmel Studio 6.1 ToDo Manager Extension You're about to exceed the limitations of my medication.
I know what you mean: I used to design industrial printers for products on conveyors. One of them went in a cement factory, and one guy had the job of making sure the printer was working fine, then standing at the end of the conveyor catching cement bags and stacking them on a pallet for eight hours a day...
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
-
Anybody found a "nice" way to get users to create and use complex filters? I have simple filters and they work well: A drop down for Type: Name, and four different classes. If it's the name, then they get a drop down to select "Contains", "Starts with", "Ends with", "Does not contain" and so forth together with a text box. If it's one of three classes, you get a drop down for "Includes all of", "Includes any of", "Includes none of", and "Does not include", together with a dropdown list of valid values. The final class gets just "Is in" and "Is not in" and a dropdown list. All grouped up in a simple control that I feed a list, and it does the filtering. No problems. Now I've had a request for making it more complex:
"Name Contains 'ABCD' AND Class Includes any off <list> OR Otherclass Is not in <AnotherList>"
for example. Coding wise this is a doodle - that's partly why I made a filter control in the first place. It's trying to work out how to present it to an average user so it's easy to create, understand and edit that's giving me problems. I was thinking of a tree of some kind so it's obvious if the example above is
"A AND (B OR C)"
or
"(A AND B) OR C"
but I'm not sure a tree is that obvious to the average joe... Anyone seen a good way? And I'm not after code, just the presentation ideas - so this isn't a programming question! :laugh:
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
I have designed a simple filter control for LIKE as well as AND/OR logic. For anything more complex I have an export to Excel button with which the users can export the data and use the Excel filters - my view is that if the user wants sophisticated filtering then outside of using SQL, Excel is probably the next best thing.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
-
Oooo! That's not bad - a single curly bracket on the LHS "pointing" at the grouping term...
/ A | / / And - | \\ / |Or - \ B
\
|
\ CNeed a bit of thinking about, but that could work. Not sure how you make it obvious how to add a grouping, but that could work...
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
Spot on.
OriginalGriff wrote:
Not sure how you make it obvious how to add a grouping
A clickable "plus" between the operator and the bracket adds either a new operator or a new value.
Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln
-
Anybody found a "nice" way to get users to create and use complex filters? I have simple filters and they work well: A drop down for Type: Name, and four different classes. If it's the name, then they get a drop down to select "Contains", "Starts with", "Ends with", "Does not contain" and so forth together with a text box. If it's one of three classes, you get a drop down for "Includes all of", "Includes any of", "Includes none of", and "Does not include", together with a dropdown list of valid values. The final class gets just "Is in" and "Is not in" and a dropdown list. All grouped up in a simple control that I feed a list, and it does the filtering. No problems. Now I've had a request for making it more complex:
"Name Contains 'ABCD' AND Class Includes any off <list> OR Otherclass Is not in <AnotherList>"
for example. Coding wise this is a doodle - that's partly why I made a filter control in the first place. It's trying to work out how to present it to an average user so it's easy to create, understand and edit that's giving me problems. I was thinking of a tree of some kind so it's obvious if the example above is
"A AND (B OR C)"
or
"(A AND B) OR C"
but I'm not sure a tree is that obvious to the average joe... Anyone seen a good way? And I'm not after code, just the presentation ideas - so this isn't a programming question! :laugh:
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
-
Anybody found a "nice" way to get users to create and use complex filters? I have simple filters and they work well: A drop down for Type: Name, and four different classes. If it's the name, then they get a drop down to select "Contains", "Starts with", "Ends with", "Does not contain" and so forth together with a text box. If it's one of three classes, you get a drop down for "Includes all of", "Includes any of", "Includes none of", and "Does not include", together with a dropdown list of valid values. The final class gets just "Is in" and "Is not in" and a dropdown list. All grouped up in a simple control that I feed a list, and it does the filtering. No problems. Now I've had a request for making it more complex:
"Name Contains 'ABCD' AND Class Includes any off <list> OR Otherclass Is not in <AnotherList>"
for example. Coding wise this is a doodle - that's partly why I made a filter control in the first place. It's trying to work out how to present it to an average user so it's easy to create, understand and edit that's giving me problems. I was thinking of a tree of some kind so it's obvious if the example above is
"A AND (B OR C)"
or
"(A AND B) OR C"
but I'm not sure a tree is that obvious to the average joe... Anyone seen a good way? And I'm not after code, just the presentation ideas - so this isn't a programming question! :laugh:
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
-
Anybody found a "nice" way to get users to create and use complex filters? I have simple filters and they work well: A drop down for Type: Name, and four different classes. If it's the name, then they get a drop down to select "Contains", "Starts with", "Ends with", "Does not contain" and so forth together with a text box. If it's one of three classes, you get a drop down for "Includes all of", "Includes any of", "Includes none of", and "Does not include", together with a dropdown list of valid values. The final class gets just "Is in" and "Is not in" and a dropdown list. All grouped up in a simple control that I feed a list, and it does the filtering. No problems. Now I've had a request for making it more complex:
"Name Contains 'ABCD' AND Class Includes any off <list> OR Otherclass Is not in <AnotherList>"
for example. Coding wise this is a doodle - that's partly why I made a filter control in the first place. It's trying to work out how to present it to an average user so it's easy to create, understand and edit that's giving me problems. I was thinking of a tree of some kind so it's obvious if the example above is
"A AND (B OR C)"
or
"(A AND B) OR C"
but I'm not sure a tree is that obvious to the average joe... Anyone seen a good way? And I'm not after code, just the presentation ideas - so this isn't a programming question! :laugh:
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
OriginalGriff wrote:
Anybody found a "nice" way to get users to create and use complex filters?
It's called a "user guide". With screenshots. And don't assume that anything is not worth explaining. Using a new prog can be scary, to people whose jobs depend on their using them properly, so help them gain confidence by explaining every detail in very simple language (i.e. don't use any programming terms). - Show what to click, and explain what it is. - Show how to select, and explain what they're selecting. - Etc.
I wanna be a eunuchs developer! Pass me a bread knife!
-
OriginalGriff wrote:
Anybody found a "nice" way to get users to create and use complex filters?
It's called a "user guide". With screenshots. And don't assume that anything is not worth explaining. Using a new prog can be scary, to people whose jobs depend on their using them properly, so help them gain confidence by explaining every detail in very simple language (i.e. don't use any programming terms). - Show what to click, and explain what it is. - Show how to select, and explain what they're selecting. - Etc.
I wanna be a eunuchs developer! Pass me a bread knife!
The problem with user guides (and I've written enough of 'em) is that people don't read them - and with a good interface they shouldn't need to for most tasks. For example: I learnt to drive a long time ago, but most of last month I spent in a hire car while mine was mended - a brand new Ford Fiesta Diesel. Now, Ford have been around for a long time, and (should) have most things right by now: I've driven enough of their cars over the years to see progress. But I had to stop the car, find the manual, trawl through it and hunt down some information: how to activate the rear window wiper in the rain. Why? Because it is on a stalk that you can't see at all from the drivers normal seated position (it's hidden by one of the "fat bits" of the steering wheel at 10 & 2) and labeled on the top surface so you have to lean all the way forward and far to the left, then look hard right and down to see the pictogram - which isn't a good idea when you're doing 70! :laugh: That's not a "good user interface" because the mechanism you need to use is hidden from you and you have to look it up and remember it instead of seeing a control and pressing it. I'm after the "there's the button, press it" type of UI on this, so they don't have to look in the manual! :laugh:
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
-
I agree. If the user is going to enter the query in textual expression form they probably don't need it represented in another form by the GUI. The graphical builder can close/grey out at that point. The good thing about the dual approach is discoverability. The user can begin constructing a query with the slow but simple GUI, see how the textual Boolean expression works with &&, ||, ! and the various functions and then cut to exactly what they want by typing it in. Most users will initially ignore the code string being built up for them but will absorb subconsciously and quite effortlessly what &&, || and ! mean. When they later see a Boolean expression they'll understand what it means and they probably won't even know how. It will just be obvious. :)
"The secret of happiness is freedom, and the secret of freedom, courage." Thucydides (B.C. 460-400)
I'd strongly suggest using "and", "or", "not" rather than the C-Style symbols. Unless the user is a programmer, there is no reason to assume familiarity with these. Further, in the absence of bit-wise operations, why on earth use "&&"?
"If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.
-
The problem with user guides (and I've written enough of 'em) is that people don't read them - and with a good interface they shouldn't need to for most tasks. For example: I learnt to drive a long time ago, but most of last month I spent in a hire car while mine was mended - a brand new Ford Fiesta Diesel. Now, Ford have been around for a long time, and (should) have most things right by now: I've driven enough of their cars over the years to see progress. But I had to stop the car, find the manual, trawl through it and hunt down some information: how to activate the rear window wiper in the rain. Why? Because it is on a stalk that you can't see at all from the drivers normal seated position (it's hidden by one of the "fat bits" of the steering wheel at 10 & 2) and labeled on the top surface so you have to lean all the way forward and far to the left, then look hard right and down to see the pictogram - which isn't a good idea when you're doing 70! :laugh: That's not a "good user interface" because the mechanism you need to use is hidden from you and you have to look it up and remember it instead of seeing a control and pressing it. I'm after the "there's the button, press it" type of UI on this, so they don't have to look in the manual! :laugh:
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
OriginalGriff wrote:
people don't read them
Hmm, I've found that not to be true. People only don't read the ones that are written badly, or that are not written from their perspective (one element of that perspective that's often forgotten is "I don't want to read the whole bluddy book! Just tell me which buttons to click and what to fill in to do A!") Most users who tend not to read user guides have anecdotes on how they were doing something the hard way, but found the easy way when browsing the user guide out of boredom (or when looking for something else). My hand is in the air for that one.
OriginalGriff wrote:
with a good interface they shouldn't need to for most tasks
Absolutely. As I say, though, users are people whose salaries depends on their using the product well, and there is a definite fear/nerve/unwillingness to change factor (especially after big updates), which a good user guide can help overcome.
I wanna be a eunuchs developer! Pass me a bread knife!
-
Anybody found a "nice" way to get users to create and use complex filters? I have simple filters and they work well: A drop down for Type: Name, and four different classes. If it's the name, then they get a drop down to select "Contains", "Starts with", "Ends with", "Does not contain" and so forth together with a text box. If it's one of three classes, you get a drop down for "Includes all of", "Includes any of", "Includes none of", and "Does not include", together with a dropdown list of valid values. The final class gets just "Is in" and "Is not in" and a dropdown list. All grouped up in a simple control that I feed a list, and it does the filtering. No problems. Now I've had a request for making it more complex:
"Name Contains 'ABCD' AND Class Includes any off <list> OR Otherclass Is not in <AnotherList>"
for example. Coding wise this is a doodle - that's partly why I made a filter control in the first place. It's trying to work out how to present it to an average user so it's easy to create, understand and edit that's giving me problems. I was thinking of a tree of some kind so it's obvious if the example above is
"A AND (B OR C)"
or
"(A AND B) OR C"
but I'm not sure a tree is that obvious to the average joe... Anyone seen a good way? And I'm not after code, just the presentation ideas - so this isn't a programming question! :laugh:
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
You may have used Process Monitor[^]. I think it's Filter UI has one of the best UI ever.
Behzad
-
Anybody found a "nice" way to get users to create and use complex filters? I have simple filters and they work well: A drop down for Type: Name, and four different classes. If it's the name, then they get a drop down to select "Contains", "Starts with", "Ends with", "Does not contain" and so forth together with a text box. If it's one of three classes, you get a drop down for "Includes all of", "Includes any of", "Includes none of", and "Does not include", together with a dropdown list of valid values. The final class gets just "Is in" and "Is not in" and a dropdown list. All grouped up in a simple control that I feed a list, and it does the filtering. No problems. Now I've had a request for making it more complex:
"Name Contains 'ABCD' AND Class Includes any off <list> OR Otherclass Is not in <AnotherList>"
for example. Coding wise this is a doodle - that's partly why I made a filter control in the first place. It's trying to work out how to present it to an average user so it's easy to create, understand and edit that's giving me problems. I was thinking of a tree of some kind so it's obvious if the example above is
"A AND (B OR C)"
or
"(A AND B) OR C"
but I'm not sure a tree is that obvious to the average joe... Anyone seen a good way? And I'm not after code, just the presentation ideas - so this isn't a programming question! :laugh:
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
Depends on the sophistication of the end user. For most end users the paradigm used by PivotViewer is about the limit. For higher end uses, it becomes tough to code and some BI and reporting tools are more what they are after. Who'd want an end user writing queries against an online oltp db? There's my 2 cents.
