• Replies 4 replies
  • Subscribers 414 subscribers
  • Views 74 views
  • Users 0 members are here
Related

No email address anywhere

Adria Gunter
$organization

I think I've tried every SQL I've seen and every Has/Does Not Have combination to figure out which constituents do not have an email address. Primary No/Yes isn't working. I just want a list of people who have absolutely no address anywhere, including login. I also tried email address does not have or not like %@%. Does anyone have a clue how to figure this out? 

Thanks in advance. 

Parents
  • $organization

    Primary Eaddress Flag | Does Not Have | (Yes, No), with "Search Household" checked, works just fine for me on 12.5.1.

    If you want to double-check your criteria, the "Show Query" should look like this:

    Select Distinct a.customer_no 

     From V_CUSTOMER_WITH_PRIMARY_GROUP a  WITH (NOLOCK)

     Where IsNull(a.inactive, 1) = 1 

     AND NOT EXISTS (select * from vs_eaddress WITH (NOLOCK) where vs_eaddress.customer_no in (select  expanded_customer_no from V_CUSTOMER_WITH_PRIMARY_GROUP where customer_no = a.customer_no) and vs_eaddress.primary_ind IN ('N','Y'))

Reply
  • $organization

    Primary Eaddress Flag | Does Not Have | (Yes, No), with "Search Household" checked, works just fine for me on 12.5.1.

    If you want to double-check your criteria, the "Show Query" should look like this:

    Select Distinct a.customer_no 

     From V_CUSTOMER_WITH_PRIMARY_GROUP a  WITH (NOLOCK)

     Where IsNull(a.inactive, 1) = 1 

     AND NOT EXISTS (select * from vs_eaddress WITH (NOLOCK) where vs_eaddress.customer_no in (select  expanded_customer_no from V_CUSTOMER_WITH_PRIMARY_GROUP where customer_no = a.customer_no) and vs_eaddress.primary_ind IN ('N','Y'))

Children
No Data