Merging queries saying 0

@Ryan Moore Why not create just one query with people who donated to Fund X (also make sure you use the gift types that you use (Cash, pledge, etc) and Solicitation code does not equal DO NOT SOLICIT (or where ever you have that code). No reason to merge queries.

@Ryan Moore
use constituent query (1 is all that you need)

• criteria
  • summary of gift amount > certain amount
    • sub criteria for gift type and gift date (maybe) and (fund is X OR appeal is Y)
  • Solicitor code not equals to DO NOT SOLICIT

use of summary of gift amount will avoid dup rows in your query.

@Ryan Moore
query condition needs to be exact logic, and will work properly.

A or B and C is not the same as (A or and C.

so your logic would work if you do

( [give to this or that]

OR [gave because of this or that] )

AND DO NOT SOLICIT

without the proper paranthesis, your logic is more like: [gave because of this or that] AND DO NOT SOLICIT
or all who [give to this or that] (which does not take into consideration of DO NOT SOLICIT)

@Ryan Moore ? It happens.

Because we have ‘do not solicit/email/mail’ coding in a variety of places after 20+ years of using RE, I also have master exclusion (actually inclusion) queries that pulls out all those we can't solicit/email/mail/etc. and I based my donor/mail/email pulls on those queries. Saves lots of time entering the exclusion criteria or even merging. Seems to be working for us.

@Ryan Moore
you cannot “nest” paranthesis in RE Query, that is true, that's why “workaround” exists, but sometime these workaround is not neccessary, it really depends on the complexity of your criteria.

looking at your post:

( CON_ID = notblank

AND ( gave to appeal & gift > $ )

OR ( gave to fund & gift > $ )

AND address_line1 = notblank )

red color is not needed. but to be exact:

if your intent is to get a list of gift (gift query) where the gift is $1K+ to a certain appeal OR a certain fund and that their address line 1 is not blank.

if you are trying to do a constituent query of those who HAS a single gift of $1k+ to a certain appeal or fund and that their address line 1 is not blank, you would basically use the same as above using the “Gift” Section in the constituent query.

keep in mind you are criteria-ing on a 1-to-many relationship (single gift has many split), you may get dup rows, how to handle dup is important in Querying.

double paranthesis situation cannot happen in RE Query so this situation would need “special handling”:

((A or and D) or E

say for example:
A = pledged $1000 in 2025 (use summary of gift)
B = pledged $1000 in 2024 (use summary of gift)
D = Preferred Address State in New York
E = Constituent Code = National Board Member

in English:
I want to get constituent who pledged $1000 in 2025 or pledged $1000 in 2024 that lives in New York state. Add to the list all who are coded as National Board Member in Constituent Code (regardless of they live in NY or gave anything in 2024 / 2025).

Since you cannot do double paranthesis, you will have to do something like:
(X and (A or and D) or E
where X is always TRUE, so it doesn't affect the overall logic within the “outter” paranthesis, since it is using a AND condition. (sometime you need X to be always FALSE if the outter paranthesis is using OR.