How to create a convenient filter

Question

Our application displays a lot of useful information for our users in a table. We have a filtering ability based on logical / logical searches. Even after training, users still don’t understand how to use filters, because AND OR → =, etc. Are strangers to them. This filter is easy for programmers because it is easily translated into code. Any examples of how this can be made more convenient and less error prone?

Answer 1

In web applications, telerik had a good idea with their network , you can also do this in desktop applications.

Answer 2

In the past, when I needed to solve this problem, I presented users with a list of elements (in one or more columns) and gave them one text box for entering text. Then I matched the text with the text in the columns and collapsed the list (deleting entries that do not match) as they were entered.

This approach is reminiscent of Google users. Everyone knows how to google.

If you do not like the idea of ​​presenting a large list of all elements initially, you can first display an empty results pane and display the results after entering the query.

Answer 3

. ,

, [ ], [ ] [ ]

[ ] -

[ ] -

: , , 10 $

, , . , n .

Answer 4

- ,

" ", , /

Wiki

QBE

, MikeD

Answer 5

, AND OR. , ANDing ORing. , :

• , .

• , ANDed . ( IN()), ( BETWEEN), ( LIKE) (, Customer ID: 1-10, 50, 52).

, .

, ORing, " ".

Answer 6

. , , . , :

Breed == "Spaniel" AND (Age == 2 OR Colour == "White")

:

 (  And/Or Field    Operator Value
[ ]        [Breed]  [=]      [Spaniel]
[1] [AND]  [Age]    [=]      [2]
[1] [OR]   [Colour] [=]      [White] 

:

AND
    [Breed] [Is Equal To] [Spaniel]
    OR
        [Age]    [Is Equal To] [Spaniel]
        [Colour] [Is Equal To] [White]

, .

:

Show ALL records where
    [Breed] [Is Equal To] [Spaniel]
    Show ANY records where
        [Age]    [Is Equal To] [Spaniel]
        [Colour] [Is Equal To] [White]

, , AND OR . , .

Answer 7

, Django .

docs, , .

, Django, , .

Answer 8

, - MS Access. , .

Answer 9

Teresa Neil illustrated several approaches to creating complex rule interfaces (AKA predicate clauses) in iTunes to allow the posting of an attached Dillema article . There are some good examples here. I really like how Apple does this in iTunes (although I do not use iTunes).