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
(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.
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
It is something on my wishlist.
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.