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 ReccaSent: Friday, September 23, 2011 4:21 PMTo: Ryan CrepsSubject: [Tessitura Development Forum] Total # of Constituents
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!
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ryan CrepsSent: Friday, September 23, 2011 4:31 PMTo: Ryan CrepsSubject: RE: [Tessitura Development Forum] Total # of Constituents
Haha, yes, that absolutely worked – thanks for your help!
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ryan CrepsSent: Friday, September 23, 2011 4:46 PMTo: Recca, SarahSubject: RE: [Tessitura Development Forum] Total # of Constituents
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