Query Issue

Michael Usiagwu

How can I write a query on RE to get the constituents who have donated to 2 campaigns only?

Joe Moretti

@Michael Usiagwu Your question needs some more information. Are your campaigns listed in the campaign tables and if they are do you want donors who have given to Both or just one or the other?

Michael Usiagwu

@Joe Moretti The campaigns are listed in campaign tables. More so, I want constituent who have given to both only.

Joe Moretti

@Michael Usiagwu Use Database View. Go to Gifts, then Campaigns. Click on Campaign ID, choose operator one of, add the two campaigns you are reporting on, click on the box "each record must meet all the specified criteria. You may also want to chose the types of gifts you want (Cash, Pledge, Recurring gift pay cash, etc. You may also want your query to utilize soft credits, especially if donors give thru donor advised funds. In tools, query options, gift processing, then choose soft credit to Both.