Phones and Emails marked Do Not and/or Inactive

@Kim Henry:

When I am doing queries in database and I want to include only emails and phone numbers that are active, I consistently also get the inactive and/or the one marked with the do not sign. How can I make sure those are excluded in my query? Thanks in Advance!

@Kim Henry,

@Alex Wong is spot on, but also keep in mind that you are querying for constituents, and not necessarily their emails and phone numbers. After applying his logic, you WILL still see constituents in your results that have at least one inactive or DNC email or phone number appearing, if they also have one that is active or not DNC.

It is important to consider what you will ultimately be doing with your query, because going through the work to exclude the inactive and DNC information may not be necessary. If you are using this as an input query for an email using any Blackbaud tools, it should suppress the emails. If you want to see the information on a mailing list or report - basically any spreadsheet - you will want to run it through an Export anyway, which is where you can more easily refine the output. When that is the case, I rarely worry about all of those details in Query.

@Kim Henry
just want to clarify a point, which from reading your reply, I feel you may have confused my response.

in RE, Phone and Email (and fax and website) were originally all consider “phone”.

while the newer version of RE (database view version v7.95+) distinguish between phone and email into separate “tab” on the constituent Bio1 tab, in Query, it is all under “Phone” subsection.

What I posted:

• Constituent Query Filter:
  • Request no email = no
  • AND Phone Type one of (select all email type)
  • AND Phone Inactive = no
  • AND Phone Do Not Contact? = no
  • AND (Constituent Code = Board Member
  • OR Constituent specific attribute Potential Board Candidate Description = Yes)

has nothing to do with actual “phone” exporting or filtering. it is all email. Look carefully at where I have AND Phone Type one of (select all email type)

when you output the actual email (Phone Number)

it will give you email addresses that is emailable (constituent not request no email, email is not inactive and not do not contact.

Again, if you are trying to get all emailable email addresses for use in eblast tool, Query exporting using the filtering I responsed will give you just that (and paying attention to your AND and OR and paranthesis).

your output is the problem.

Don't output UT Email Address from under "Specific Phones", output Phone Number