Books > Help Center > Data Management > Data Management > Custom Reports >  

What is Advanced Filter Logic for Custom Reports?
  • Filter logic is optional when creating a Custom Orders report. It is used to specify the relationship between each of the conditions you create.
  • If you don't specify any filter logic, AND will automatically appear in the Logic column on the right hand side.
  • AND means that each condition has to be met to include an order in the report. OR means that only one of the conditions has to be met. Use a combination of AND and OR using the following rules...
  • Make sure each open parenthesis "(" has a matching close parenthesis ")".
  • Enclose conditions that have priority in parentheses. See examples below.
  • Insert one of these terms between each filter line number: AND, OR, NOT. Avoid conditions like 1 AND OR 2 and (1 2 3).
  • Begin a condition with the term NOT, but do not end one with NOT. For example, NOT 1 AND (2 OR 3 OR 4) finds records that meet any of the last three filters and excludes records that meet the first filter.
  • Advanced Filter Logic is case sensitive.  Therefore, type AND instead of and.

Example A: 

    Condition Field Operator Value
   1 Service equals Registrar
   2 State equals NY
   3 Total greater than $100

  • 1 AND 2 AND 3 (default filter logic)
    This filter finds only those Event Registrar orders that are both from New York and over $100.
  • (1 AND 2) OR 3
    This filter finds all Event Registrar orders from NY as well as orders from any service and any state that are over $100.
  • 1 AND (2 OR 3)
    This filter finds Event Registrar orders that are either from NY or over $100. To create the same report you could also use (1 AND 2) OR (1 AND 3).

Example B: 

    Condition Field Operator Value
   1 Service equals Shopping Cart
   2 State equals CA
   3 Total greater than $50
   4 Item Name equals Logo T-Shirt

  • (1 AND 2) OR (3 AND 4)
    This filter finds records that match both the first two filter lines or the second two filter lines. In this case, the report would pull all Shopping Cart orders from CA as well as all the orders from any service and state that had a total of over $50 and ordered a Logo T-Shirt.
  • (1 OR 2 OR 3) AND 4
    This filter finds records that match any of the first three filter lines that also include the last. In this case, the report would pull all orders for Logo T-Shirts that were purchased through the Shopping Cart service, or any service from California, or from any service and state that totaled more than $50.

Was this information helpful?
Yes   No

Search Help Center

Today's Top 10 Articles
  1. 2011-01-07: Raiser's Edge Import Files
  2. How do I add a thermometer image for my Pledge-a-thon to my website?
  3. How do I get copies of confirmation emails to come to me?
  4. Consider a long-term pledge-a-thon or virtual campaign
  5. What is the difference between participants, donors & pledgers?
  6. How do I create a Pledge-a-thon?
  7. How do I customize my password-protected Member's Site?
  8. How do I remove someone from a team?
  9. How do I change the Tax Receipt setup?
  10. What should I do when I receive an error notification for a recurring donor?