Query for constituents without a specific alias type

Options
Scott Turnbull
Scott Turnbull ✭
Third Anniversary First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion

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 ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic

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

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic

    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 First Reply

    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 ✭
    Ancient Membership Facilitator 2 Name Dropper Photogenic

    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 First Reply

    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 2
    Aldera Chisholm 2 ✭✭✭✭✭
    Sixth Anniversary Facilitator 2 Name Dropper Photogenic

    “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