Query for constituents without a specific alias type

Scott Turnbull
Scott Turnbull
Third Anniversary Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussions

I want to pull a list of constituent IDs that do not have a specific alias type. When I build this I get a repeating list of constituent IDs, each for the alias type that doesn't equal the one I want to exclude, but that not the same as giving me a list of constituent ID that don't have that alias type at all.

Tagged:

Comments

  • JoAnn Strommen
    JoAnn Strommen Community All-Star
    Tenth Anniversary Kudos 5 March 2026 Challenge: Answered Questions January 2026 Monthly Challenge

    Have you tried taking the query to the Export function to get one record per ID?

  • JoAnn Strommen
    JoAnn Strommen Community All-Star
    Tenth Anniversary Kudos 5 March 2026 Challenge: Answered Questions January 2026 Monthly Challenge

    Sorry, @Scott Turnbull looks like you may be new to RE, welcome to the BB Community. I should have explained a bit more. Many fields like phone, email, gifts, etc. will create duplicate lines in a constituent query. This is because more than one applies.

    This is when you use constituent Query as your grouping tool, pulls together the relevant records, and then take the query to constituent Export to get the data you want with just one row per record.

  • Scott Turnbull
    Scott Turnbull
    Third Anniversary Facilitator 1

    Thanks for your reply. I may not be phrasing my question well. I understand the export filter but that's not what I need.

    What I want is a list of Constituent IDs that do not have a particular type of alias. There doesn't seem to be a way to get that. What I get is a list of all the other alias with their constituent ID, but it doesn't mean it doesn't have the alias I'm trying to exclude. I basically need an LEFT OUTER JOIN

    I could export a list of all Constituent IDs, then a list of constituent IDs that have the alias type in question, and then produce an exclusion list but I was hoping there was some method without having to dump all that out and massage it manually.

  • Nicole Holt
    Nicole Holt Community All-Star
    Tenth Anniversary Kudos 5 Name Dropper Participant

    I think you'd have to merge queries or use a query list--create a query of everyone and subtract a query of those with the specific alias type.

  • Scott Turnbull
    Scott Turnbull
    Third Anniversary Facilitator 1

    Thanks, that would still give me constituent ids that have an alias other than the alias I was looking for.

    Ultimately what I ended up doing was exporting a list of all constituent ids with the alias and getting my other data and writing a small script to do what I need but excluding any of the ids in the alias list.

  • Aldera Chisholm
    Aldera Chisholm
    Sixth Anniversary Kudos 5 PowerUp Challenge: Data Health #3 First Reply

    “This is the way” … I've been doing a lot of this lately, trying to clean up old records. Very rarely do I review data in query, unless it's pretty simple - export is ideal for this. I've been doing searching for missing add/sal and missing alias using this method and it works well.

Categories