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.


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
-
mollyschar commented
Yes! This is a big one for me, too. I am constantly having to run two or three searches and then add totals together or combine spreadsheets as a workaround. A common query for me would be:
Renewal due this month
AND
Membership level = Premier Business OR Membership level = Premier Medical
Or perhaps:
Role = consultant
AND
Renewal due on or after January 1, 2011 OR Registered for specific events
This, of course, isn't as advanced as it could go if we could also use BUTS. I'd be happy with the AND/OR options.
Thanks!
-
Dmitry Buterin commented
John,
Thanks for posting.
The reason we are reluctant to add Boolean search is because for non-technical people (majority of our users) it might make things confusing and unnecessarily complicated. I would appreciate examples of searches you need to run but currently can't in WA so that we can look at possible solutions.
About access to all fields - please email us at support @wildapricot.com with details
About exporting subset of fields - understood, there is a separate thread on that.
-
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