Every place an add/sal could be?

Amy Barker 7

I used to have an amazing query that would search every possible place for a specific add/sal. Sadly, that query is long gone. Does anyone have a screenshot of the criteria, so I can rebuild?
wish I had access to SQL, alas, I do not.

Thanks!!!

Christine Cooke 2

@Amy Barker every constituent, and every relationship has an add/sal field. Write the query with OR for each of those fields.

JoAnn Strommen

@Amy Barker Am watching for great replies with something I might have missed. I'm working on a lot of clean up projects: add/sal, address types, attributes, constit codes and often can not find the elusive entry of the data.

With queries be sure to include deceased, inactive and no valid address on the set up page. And as Christine posted be sure “OR” is used for all the search criteria. Be sure you have rights to all records - sometimes some users do not.

I've had to resort to marking as inactive / moving to bottom of the list etc. Only so much time in the day. ?

Isaac Comer

@Amy Barker Addressee/Salutations can also show up in Memberships, and in the “Tags/Cards” section of an Event Participant.

I have not checked to see if all of those areas are query-able and/or export-able.

I'm also not sure if that's all the possible locations.

JoAnn Strommen

@Isaac Comer LOL I saw membership listed in KB 52877

Note: Use the one of operator instead of equals if querying on several addressee/salutations. An addressee/salutation format can be used by record types other than constituent. To find all instances of an addressee/salutation format in the database, create relationship, participant, and membership queries as well.

We don't have membership module but have been trying to query for participants. Where are you finding a place to select add/sal format in tags/cards? I don't see add/sal as a criteria or a format option for Tags/Cards.

This really is frustrating when query keeps pulling “0”!

Isaac Comer

@JoAnn Strommen
1.Open an existing Membership record

2.Click “Members & Cards”

3.Double click any one of the rows in the “Other Members and Card Information” popup

4.If “Editable” is checked, uncheck it.

Now “Name on card” becomes blank and has a drop down arrow next to it. The list presented is a combined list of Addr/Sal – first ones from the Individual’s record, then from Configuration Table

Isaac Comer

@JoAnn Strommen
Please ignore the previous response. Despite you saying you don’t have the Membership module, for some reason, I answered as if that was your question.

On an Event Participant the Addr/Sal stuff is here:

Open a Participant, then click Tags/Cards. The “Name to print” dropdown pulls from Addr/Sal – both the ones on the Participant’s constituent record (if they have one) and also from the Configuration Table.

Amy Barker 7

Thank you for your replies. I'm more looking for the hidden places Add/Sals can hide. (Nametags, etc.) Thankfully we don't have the membership module, so that removes that mess from the equation. I think I have narrowed things down to the bad add/sals being on ancient event nametags, and being marked editable.
If I ever find that query set up I will share it.

Amy Barker 7

@Isaac Comer name tags are able to be queried on. I was just wracking my brain to find any other places they could be.

Isaac Comer

@Amy Barker
The RE7Schema.chm file is a little bit outdated these days, but it is probably still accurate enough to help here.

According to it the SALUTATIONS table is referenced by all of the RE tables in the left-hand column:

So that means in addition event participants possibly having name tags, there's also place cards.

I can't 100% guarantee it, but that would seem to be it. Because AFAIK the only major update to RE that's not represented in the schema documentation is the GDPR Consent stuff.

Constituent_Salutation corresponds to the Additional Addr/Sal section of the Constituent Addr/Sal tab.

MembershipCards obviously goes to the Membership table.

Both the Participant ones appear in the same popup.

And the other two in RECORDS are for the Primary Addressee and Primary Sal on the Constituent Add/Sal tab.

According to the documentation, that's all of the places an Addr/Sal can live.

Amy Barker 7

@Isaac Comer
Exactly what I was looking for! Schema! Covid brain would not let me find that word. Thank you!