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
66 comments
-
John Dandurand
commented
This is a normal function for every single database I have used until WA. It does not seem to me that this should be an 'optional' feature. Lack of this functionality severely cripples searches. Additionally users need to be able to:
* have access to all of the fields when searching, not just a subset for each module
* choose which fields they want to export from a list of all fields in the database -
John Dandurand
commented
WA's search features are woefully limited. Users need to be able to:
* conduct multiple contiguous searches (e.g., a and b but not c OR d and e but not f, etc.)
* have access to all of the fields when searching, not just a subset for each module
* choose which fields they want to export from a list of all fields in the database -
maryrobinette
commented
Yes, this would be enormously helpful. For instance, when I'm sending out emails to members who might be close to a convention in Oregon, I want to alert people in CA, ID, OR and WA. At the moment I either have to send four emails or select "is not" for all the other states.
-
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
