Total # of Constituents

Does anyone know how to find out the total number of constituents that are in their Tessitura database?  I was told that if you entered the '%' sign in the 'lname' search field and press enter and it would come up with all constituents in the database.  That doesn't seem to be working though. Any other ideas??

Thanks!
Sarah

  • How about:

     

    ConstituentId >= 1

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sarah Recca
    Sent: Friday, September 23, 2011 4:21 PM
    To: Ryan Creps
    Subject: [Tessitura Development Forum] Total # of Constituents

     

    Does anyone know how to find out the total number of constituents that are in their Tessitura database?  I was told that if you entered the '%' sign in the 'lname' search field and press enter and it would come up with all constituents in the database.  That doesn't seem to be working though. Any other ideas??

    Thanks!
    Sarah




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

  • In List Manager:

    Inactive Flag - IN -  Active

    Should work.

  • I thought that you were referring to List Manager, but I think you are looking at Constituent Search.  Sorry for any confusion!

     

    If you go to List Manager, start a new list, and use the criteria ConstituentId, operator “>=”, and enter 1, this will give you a list containing all constituents.  I would recommend against opening the list contents though!

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Friday, September 23, 2011 4:31 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Development Forum] Total # of Constituents

     

    How about:

     

    ConstituentId >= 1

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sarah Recca
    Sent: Friday, September 23, 2011 4:21 PM
    To: Ryan Creps
    Subject: [Tessitura Development Forum] Total # of Constituents

     

    Does anyone know how to find out the total number of constituents that are in their Tessitura database?  I was told that if you entered the '%' sign in the 'lname' search field and press enter and it would come up with all constituents in the database.  That doesn't seem to be working though. Any other ideas??

    Thanks!
    Sarah




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

  • Haha, yes, that absolutely worked – thanks for your help!

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Friday, September 23, 2011 4:46 PM
    To: Recca, Sarah
    Subject: RE: [Tessitura Development Forum] Total # of Constituents

     

    I thought that you were referring to List Manager, but I think you are looking at Constituent Search.  Sorry for any confusion!

     

    If you go to List Manager, start a new list, and use the criteria ConstituentId, operator “>=”, and enter 1, this will give you a list containing all constituents.  I would recommend against opening the list contents though!

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Friday, September 23, 2011 4:31 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Development Forum] Total # of Constituents

     

    How about:

     

    ConstituentId >= 1

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sarah Recca
    Sent: Friday, September 23, 2011 4:21 PM
    To: Ryan Creps
    Subject: [Tessitura Development Forum] Total # of Constituents

     

    Does anyone know how to find out the total number of constituents that are in their Tessitura database?  I was told that if you entered the '%' sign in the 'lname' search field and press enter and it would come up with all constituents in the database.  That doesn't seem to be working though. Any other ideas??

    Thanks!
    Sarah




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

  • Typing %%% in the last name field will work, and will return inactive accounts as well—but if your database is of any size, it will take a long time to run. I use %%% when I know the first name, but not the last name.

     

    Lucie

    Florida Grand Opera