List of All Performances

Hi Sheela –

I’d recommend a quick SQL query, to be honest:

SELECT DISTINCT p.perf_no as 'Performance ID', p.perf_dt as 'Performance date', v.perf_name as 'Performance', p.def_start_sale_dt as 'Default start sale date'

FROM T_PERF p
JOIN VS_TICKET_HISTORY v on p.perf_no = v.perf_no

ORDER BY p.perf_dt

That should sort you out. Bear in mind that the “sale start date” you talk about can mean several different things… Different modes of sale can have different start dates, for example. The query I’ve written above uses the default start date, which might be the simplest thing.

If you want only performances in the future, add WHERE p.perf_dt >= GETDATE() between the line starting “Join” and the line starting “Order”.

Hope this helps,

C.//
X.

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Sheela Sur
Sent: 23 March 2015 03:53
To: Chris Campbell
Subject: [Tessitura Ticketing Forum] List of All Performances

Is there a way to get a list of all Performances - including performance date, performance ID, performance name, and sale start date? Basically what's included in the Performance tab in v12 but in a spreadsheet?

Thanks so much,

Sheela

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!

Hi Sheela –

I’d recommend a quick SQL query, to be honest:

SELECT DISTINCT p.perf_no as 'Performance ID', p.perf_dt as 'Performance date', v.perf_name as 'Performance', p.def_start_sale_dt as 'Default start sale date'

FROM T_PERF p
JOIN VS_TICKET_HISTORY v on p.perf_no = v.perf_no

ORDER BY p.perf_dt

That should sort you out. Bear in mind that the “sale start date” you talk about can mean several different things… Different modes of sale can have different start dates, for example. The query I’ve written above uses the default start date, which might be the simplest thing.

If you want only performances in the future, add WHERE p.perf_dt >= GETDATE() between the line starting “Join” and the line starting “Order”.

Hope this helps,

C.//
X.

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Sheela Sur
Sent: 23 March 2015 03:53
To: Chris Campbell
Subject: [Tessitura Ticketing Forum] List of All Performances

Is there a way to get a list of all Performances - including performance date, performance ID, performance name, and sale start date? Basically what's included in the Performance tab in v12 but in a spreadsheet?

Thanks so much,

Sheela

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!