Add Boolean logic to Advanced Search
It would be nice to be able to search the member database (or any database really) by specifying criteria such as:
Renewal_Due on or after Sept. 16,2008
AND
(MembershipLevel = Gold OR MembershipLevel = Silver)
Right now, I think, I can only choose to AND (i.e., Match ALL) all the criteria or OR (i.e., Match ANY) all the criteria -- no mixing AND's and OR's. This is okay for very simple reports with only two criteria, but often not what is needed for reports with more than 2 filter criteria.
Kim Skimmons
shared this idea
Evgeny Zaritovskiy
responded
Old design proposal, not working on it yet and can be changed if we start working on it – https://drive.google.com/file/d/0B0f9kMyQqlBsZ3FQOWRiMERRNkk/view?usp=sharing
63 comments
-
Teri
commented
It is something on my wishlist.
Teri
OFLA
-
Dmitry Buterin commented
Paul, as you can see, this thread did not have any comments before yours so for now we are not really planning it in our roadmap - seems to be less important to our users than dozens of other things. So we will wait to hear more input here.
-
Paul at PEN
commented
Any chance of this happening? AND, OR & NOT between each search criterion? It seems like a strange lack for an advanced search system.
Thanks,
Paul
