Type in your suggestion - new feature or improvement idea

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


(Membership_Level = Gold OR Membership_Level = 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.

112 votes
Sign in
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Kim Skimmons shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: Facebook Google
Signed in as (Sign out)
  • Steven Reames commented  ·   ·  Flag as inappropriate

    This is a fundamental search capability for most databases and clearly a high priority for users who've expressed their wishes. Why isn't this a priority for Wild Apricot?

  • laurastigler commented  ·   ·  Flag as inappropriate

    In Advanced Search, when putting in more than one criterion, there should be the words "and" and "or" between each that could be checked. For instance, let's say my two criteria are 1) "Initial Contact"... is... "Museum" 2) "Notes" ...contain..."Museum". My desire would be to get a list of all non IWOC members who attended our talk at the Museum, but also there were few current IWOC members who attended that same talk. So I'd like one list that included all those people who were at the talk. Couldn't get it. But if an "and" were between those two criteria, that complete list would have been compiled. Hope I made myself clear!

  • Michael James commented  ·   ·  Flag as inappropriate

    How about a real boolean search with a field sector that inserts the correct field name in the search. The IT people for the org will create these complex ones and then publish just a saved search, or a a report to the people that need to use it.

    ("Membership Level" -eq "Monthly" -or "Membership Level" -eq "Annual") -and "Member Status" -eq "Active")

  • Jon Carlson commented  ·   ·  Flag as inappropriate

    Contact and member searches (particularly saved searches) need to be able to apply the "ANY"/"ALL" (i.e. "OR"/"AND") logic in a mixed way. For example, I might need to search for (Member Level of X OR Y) AND (Member Status is ACTIVE). That's just one simple example. Give me a way to group them and then connect the groups.

    Possible way to present the concept - chain the searches. So build one search with ANY logic, then build another search with ANY logic, then chain the two with AND logic. Something along those lines.

  • Lynn B commented  ·   ·  Flag as inappropriate

    There are several suggestions for vastly improving Advanced Search. E.g., checkboxes instead of radio buttons to allow for logic such as

    (renewal preference = Paper AND (membership level = GOLD OR membership level = SILVER)

    Why hasn't it been implemented yet

  • David Turner commented  ·   ·  Flag as inappropriate

    We should be able to create email lists which include 'and' and 'Or' (not just 'is' or 'is not'. E.g. Members who are in city x AND have the title Dr.

  • Daniel Frankel commented  ·   ·  Flag as inappropriate

    Please enhance the advanced search capability to include compound queries (re (x and (y or z)). Also, add more of the SQL to the query language.

  • Nancy Scanlan commented  ·   ·  Flag as inappropriate

    I agree, let us combined Saved Searches. Would allow us to do a Boolean search divided into smaller steps. Could be easier for staff who are not clear on how to set up a single complicated Boolean search

  • John Barrett commented  ·   ·  Flag as inappropriate

    I like Michael's idea of combining Saved Searches. It is a simple and easy to understand approach to enhancing the search capabilities. Another benefit is that it also allows you to leverage existing saved searches to build new ones rather than building new ones from scratch. It also lets you make changes to many saves searches by modifying only one. The one downside I foresee with this approach would be that someone changes one Saved Search not realizing that they will be changing the results of another. However, I still like this approach.

  • Liz commented  ·   ·  Flag as inappropriate

    There's a new topic that's similar to this one. It suggests that dropdowns should also allow multiple selected in search, which makes a lot of sense. E.g. If you have a dropdown for states, and you want to find members in set of specific states, you currently have to add a new criteria for every single state. https://forums.wildapricot.com/forums/308932-wishlist/suggestions/15719559-filter-for-multiple-items-within-a-single-advanced

  • Walt Bilofsky commented  ·   ·  Flag as inappropriate

    Advanced Search already works this way for multiple choice fields. Might that make it a fast implementation for radio button fields?

    Although - what would that do to our existing saved searches? Would WA have to convert them all? Could it be done automatically?

  • Liz commented  ·   ·  Flag as inappropriate

    I concur that a partial solution would be to make searches on radio button fields allow multiple selected. Combo AND/OR searches could be added later if that's more complicated to implement.

  • Timothy Nott commented  ·   ·  Flag as inappropriate

    A UX tweak to the proposal I would suggest would be to collapse nested groups when they are not being edited so that the entire query can more easily be read at a high level. The indentation is a good indicator, but when everything is in an editable state, it is more difficult to read.

  • Walt Bilofsky commented  ·   ·  Flag as inappropriate

    One simple and helpful addition to this would be to change the radio button search criteria to multiple choice.

    For example, now the Membership Level criterion can be "is" or "is not" but only one level can be selected by the radio buttons.

    This should be changed to multiple choice so that we can select any number of membership levels in that one criterion.

    And the same for Record Status, Role, Member Status, etc.

    Of course, if and when this feature is implemented then it would provide a (more complicated) way to do the same thing. But this would make some searches cleaner.

    And if the full implementation isn't coming soon, maybe this could be done in the meantime?

  • Timothy Nott commented  ·   ·  Flag as inappropriate

    I second Walt's ask: "One simple and very helpful fix would be to change the radio button search criteria to multiple choice."

    I would add the ability to create criteria groups so that we can mix AND/OR searches. Example:

    I want to find contacts where (membership level = individual OR membership level = family) AND (membership status = active OR membership status = lapsed)

    Bonus points for nested criteria groups

← Previous 1 3

Feedback and Knowledge Base