• 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

    Hi Adria

     

    I would try eaddress type DOES NOT HAVE and then list all the eaddress types you have

     

    If this is the only criteria in your list it will bring back people who have no ACTIVE email at all – so it could be large depending upon the size of your database. When done in List Manager, of course it would exclude any inactive Constituents as well.

     

    Cheers

    Sandra

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Adria Gunter
    Sent: Thursday, May 19, 2016 9:52 AM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: [Tessitura Ticketing Forum] No email address anywhere

     

    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. 




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    Hi Adria

     

    I would try eaddress type DOES NOT HAVE and then list all the eaddress types you have

     

    If this is the only criteria in your list it will bring back people who have no ACTIVE email at all – so it could be large depending upon the size of your database. When done in List Manager, of course it would exclude any inactive Constituents as well.

     

    Cheers

    Sandra

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Adria Gunter
    Sent: Thursday, May 19, 2016 9:52 AM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: [Tessitura Ticketing Forum] No email address anywhere

     

    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. 




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data