Hello all,
I'm wondering if anyone knows of a way to run a report/extraction or anything really that will find all constituents that HAD tickets to an event. We need something that would theoretically catch anyone who exchanged out of, or received a refund due to a cancelation, as the only methods I can currently think of only display current patrons for an event.
Thanks,
Maurice
As an aside re: identifying a perf_no from within the application – it’s a little obscure but it is possible from the Seat Map.
Right click on any seat and take the “Database Seat No” option.
In the info displayed you will see the perf_no referenced there.
+ Peter Nelson
+ Tessitura Network
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ryan CrepsSent: Thursday, 5 January 2012 11:57 AMTo: Peter NelsonSubject: RE: [Tessitura Ticketing Forum] Report for Constituents when a show is canceled
Maurice,
An alternative would be to run the Performance Seating Book report for the performance. You can then save the report results to a list using the option “Save as List” under the file menu.
The performance code criteria is based on ticket history, which is typically set up to update nightly. Ticket history may not be updating on that schedule or may have an issue. One way to check is by loading a constituent that you know attended the event and checking the ticket history panel under their record.
+Ryan Creps
+Tessitura Network
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Maurice NounouSent: Wednesday, January 04, 2012 7:42 PMTo: Ryan CrepsSubject: RE: [Tessitura Ticketing Forum] Report for Constituents when a show is canceled
Thank you firstly. I gave this a try and it came back with 0 results. I think it is because there isn't the line to replace 120121LR within the query you posted. Is that the entire query or did part of it get cut off?
From: Lucie Spieler <bounce-luciespieler8144@tessituranetwork.com>Sent: 1/4/2012 6:22:13 PM
If you paste the following query into the manual edit area of a new list, and replace 851 with the perf_no of the performance you are looking for, and the 120121LR with the perf_code for the same performance, this should give you everyone who has ever had a seat reservation for a particular performance, but who is not currently ticketed as of the last time your ticket history updated (ours updates once a day, at night).
If you don’t have access to ticketing setup, I don’t know how to find the perf_no, which appears on the performance screen, in the Tessitura client. (If you can look at T_PERF via Microsoft SQL Server Management Studio, of course, that’s the easiest way.) You’ll have to get someone in IT to help you there. The performance_name appears on the ticket history screen in our system as “Perf. Name” and also on the top of a relevant seat map in the House View of Season Manager, as well as being the perf_code in an order in the ticketing module.
Select distinct a.customer_no
From t_customer a (NOLOCK)
JOIN t_order e (NOLOCK) ON a.customer_no = e.customer_no
JOIN t_sub_lineitem f (NOLOCK) on e.order_no = f.order_no
Where IsNull(a.inactive, 1) = 1
AND f.perf_no = 851 REPLACE
Lucie
______________________________
Lucie SpielerIT Development and Training Manager
Editor, Season ProgramFLORIDA GRAND opera8390 NW 25th StreetMiami, FL 33122305.854.1643 x. 1521Box Office: 800.741.1010To Give a Gift: 305.403.3315www.FGO.org2011-2012 • 71ST SEASON • LOVE FORBIDDEN, NOT FORGOTTENLuisa Fernanda • La rondine • Rigoletto • Roméo et Juliette
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!