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
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
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?