Tribute constituency codes

Wayne Pozzar

I am trying to make a query of tributes to send to our mail house. I would like to have only tributes that are for people who do not have certain constituency codes (like VIP or Board Member).



I can't seem to access Tribute Constituent->Constituency Codes in a gift query.



Has anyone else come across this?



Example to be clear:

John Doe is a Board Member

Mike Doe is NOT a Board Member





Gift 1: Mike Doe makes a gift in honor of John Doe

Gift 2: John Doe makes a gift in honor of Mike Doe





I would like a query that only gives me gift 2. Or any query that I can pass to a mailing that will have Gift 2 tribute information and not Gift 1.

Rob Rexing

Wayne Pozzar:
I am trying to make a query of tributes to send to our mail house. I would like to have only tributes that are for people who do not have certain constituency codes (like VIP or Board Member).



I can't seem to access Tribute Constituent->Constituency Codes in a gift query.



Has anyone else come across this?



Example to be clear:

John Doe is a Board Member

Mike Doe is NOT a Board Member





Gift 1: Mike Doe makes a gift in honor of John Doe

Gift 2: John Doe makes a gift in honor of Mike Doe





I would like a query that only gives me gift 2. Or any query that I can pass to a mailing that will have Gift 2 tribute information and not Gift 1.

Hi Wayne,

 

You are correct that it's not possible to query on the constituent codes of people marked as receiving Tributes from a gift query, but if I'm understanding your situation correctly, it should still be possible to do this with a couple of additional steps.


The best way I can think to do this involves using merged queries with the SUB operator.


1.       Start with a constituent query that filters on all constituents marked as Tribute equals Yes (Constituent is Honor/Memorial equals Yes)
2.       Create a second constituent query that includes all of the constituent codes you DO NOT WANT (in this case, constituent code one of VIP, Board Member)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />


3.       Merge these using SUB. The query of all Tribute constituents will be the primary query, the constituent code query will be the secondary query, and when merged, the resulting list will remove/subtract the records with the unwanted constituent codes from the original list of Tribute individuals