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. 

Parents
  • Okay. So I didn't have the Search Household button checked (DUH!). I had checked the Replace individual with household and add all primary affiliates. That didn't work. 
    I also tried Does Not Have and all of the types even the inactive ones since there seem to be some people who still have those types. I got like fifty more than the Primary EAddress Flag Does not Have Yes/No. But the control constituent I was using isn't on either of these lists which is great. Thanks Sandra and Nick and everyone else. 


    On Thu, May 19, 2016 at 1:30 AM, Sandra Ashby <bounce-sandraashby2064@tessituranetwork.com> wrote:

    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!



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/16042/48581.aspx#48581 or reply to this message

    Adria Gunter | Subscriptions and Groups Manager

    STUDIO THEATRE

    1501 14TH ST NW

    WASHINGTON DC  20005

    T  202-232-7267, ext. (365)

    F  202-588-5262

    www.studiotheatre.org

    Subscriptions are online!   Reserve your group of 10+ today and enjoy a discount!

    2015-2016 SEASON MAIN SERIES    CHIMERICA |THE APPLE FAMILY CYCLE: SORRY & REGULAR SINGING |  BETWEEN RIVERSIDE AND CRAZY  | MOMENT | HEDDA GABLER

    2015-2016 SEASON   STUDIO X    ANIMAL | CONSTELLATIONS   

    2015-2016  SPECIAL REMOUNT    BAD JEWS

Reply
  • Okay. So I didn't have the Search Household button checked (DUH!). I had checked the Replace individual with household and add all primary affiliates. That didn't work. 
    I also tried Does Not Have and all of the types even the inactive ones since there seem to be some people who still have those types. I got like fifty more than the Primary EAddress Flag Does not Have Yes/No. But the control constituent I was using isn't on either of these lists which is great. Thanks Sandra and Nick and everyone else. 


    On Thu, May 19, 2016 at 1:30 AM, Sandra Ashby <bounce-sandraashby2064@tessituranetwork.com> wrote:

    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!



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/16042/48581.aspx#48581 or reply to this message

    Adria Gunter | Subscriptions and Groups Manager

    STUDIO THEATRE

    1501 14TH ST NW

    WASHINGTON DC  20005

    T  202-232-7267, ext. (365)

    F  202-588-5262

    www.studiotheatre.org

    Subscriptions are online!   Reserve your group of 10+ today and enjoy a discount!

    2015-2016 SEASON MAIN SERIES    CHIMERICA |THE APPLE FAMILY CYCLE: SORRY & REGULAR SINGING |  BETWEEN RIVERSIDE AND CRAZY  | MOMENT | HEDDA GABLER

    2015-2016 SEASON   STUDIO X    ANIMAL | CONSTELLATIONS   

    2015-2016  SPECIAL REMOUNT    BAD JEWS

Children
No Data