Pull a list by price zone

I’d prefer to do it in T-Stats.

We also have Ticket History Zone in List Manager under Ticketing. I don’t think that is a customization.

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Brian O'Neill
Sent: Thursday, August 13, 2015 5:04 PM
To: Nicole Keating <nkeating@arshtcenter.org>
Subject: [Tessitura Ticketing Forum] Pull a list by price zone
Importance: High

Is there a way to pull a list by price zone? We have a performance with a VIP price zone and I need to pull a list for parking. I can't figure this out, I can pull a list by the price of the ticket, but that does not help me for complimentary seats in that section. Help?

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!

If you are pulling your list using ticket history, you can look at what information your ticket history table is holding. In our ticket history, zone information is in the location field, along with price type, row, and seats. Using the Manual Edit, I have the following (to find all balcony seats in a particular theater):

Select Distinct a.customer_no

 From V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock)

JOIN vs_tck_hist e (NOLOCK) ON a.customer_no = e.customer_no

Where  IsNull(a.inactive, 1) = 1

AND (e.location like '%Balc%' or e.location like '%er Bal%')

AND e.performance_name in (select perf_code from VS_PERF where facility_no = 60)

AND e.season in (82)

Lucie