Count of Subscribers with more then one Series

Hi Randy,

You can write the SQL to do this in List Manager.  Start a new list and click Manual edit.  Then you can write in the code like you would write any SQL query.  The only restriction is that the only data your query can return is constituent ID.   You might be able to get the list of constituents you want using the graphical interface, but if you already know how to write the query you need then going the Manual Edit route might be faster.

Kevin Sheehan

Documentation & Learning Resources Specialist

Tessitura Network

1 888 643 5778 ext 329 Office

ksheehan@tessituranetwork.com

Hello Tessiturians,

I curently am a new Tess User and do not have access to the sql database in our consortium.  Is there a simple way thru the Tess frontend to get a count of my Subs that have purchased 2 or more series or packages in a list with the series or packages defined? 

Thanks for the help--I'm used to doing this quickly in SQL, but am forced to do it thru the Tess Interface...Help!

Thanks,

Randy G.

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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.435 / Virus Database: 271.1.1/2661 - Release Date: 02/05/10 07:35:00