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!

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.

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

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

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.

It is something on my wishlist.

Teri

OFLA

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.

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