Skip to main content
  1. Home
  2. Support
  3. Questions

Can we create a filter with AND, OR and NOT conditions?

Bryan Gilbert By 
February 11, 2013

NationBuilder is trying to be a database of people associated with a cause. All databases provide a way to search the contents using basic query logic such as

"(Any with X ) OR (Any with Y)"   must have either X or Y

"(Any with X ) AND (Any with Y)"   must have both X and Y

"(Any with X ) AND  NOT((Any with Y))"  must have X but not Y

For example, I'd like to find all people and a city who have donated or volunteered. This is (Any with city) and ((Any with donated) OR (Any with volunteered)).

 

Official response from

By default, a filter allows for AND queries (i.e. people from a certain city and people who donated). At this time, our search logic does not allow for a single search to accomplish an OR or NOT query. For feature suggestions related to this issue and some workarounds, go here and here. Also make sure to check out Exclusion Queries and Advanced Listbuilding in NationBuilder from NationBuilder Certified Architect Richir Outreach.

Share this post

Showing 7 reactions

How would you tag this suggestion?

Sign in with

Please check your e-mail for a link to activate your account.
  • Jason Meer
    NationBuilder employee
    responded with completed
    posted 2016-06-22 09:04:37 -0700
  • Gavin DeSchutter
    NationBuilder employee
    commented
    These searches are possible with NationBuilder’s filter feature. Further documentation of these types of queries can be found here: http://nationbuilder.com/how_to_filter#all
    posted 2016-04-14 10:07:56 -0700
  • Hank Rouse
    commented
    I’d like to create a query based webpage within my NB. i.e. Owners at $500 level, and then Owners at $250 level.

    Is this possible?
    posted 2016-04-12 17:38:25 -0700
  • Rand Wrobel
    commented
    THis is pretty important. Currently, AFAIK, you cannot do exclusions with a filter, but have to do a list – which means its out of date as soon as someone joins. I’m trying to do blasts to all contacts, except certain tags. So I will have make a list for each blast, rather than a 1 time filter. So this qualifies under PIA prioritization. :-)
    posted 2013-07-23 23:08:49 -0700
  • Bryan Gilbert
    tagged this with Important
    posted 2013-07-23 23:05:48 -0700
  • Bryan Gilbert
    tagged this with Important
    posted 2013-05-11 11:45:47 -0700
  • Bryan Gilbert
    responded with planned
    posted 2013-02-11 11:46:57 -0800

Status key

  • Answered: The question has been officially answered
  • Incomplete: More information is needed to answer the question