Hi All,
I’m getting everything set up and ready for our rollover for the coming season and am hoping that someone can help me track down some groups I want to check on before I start rolling over.
Is there an easy way (either through Tessitura or a SQL query) to
1) create a list of the people who have ONLY base seats, i.e. all of the performance seats have been returned but not the base seats?
2) Find people who have base seats that are different from their performance seats?
Any help would be greatly appreciated!
Adrienne Steer | Patron Services Manager
Kitchener-Waterloo Symphony | kwsymphony.caConrad Centre for the Performing Arts36 King St W | Kitchener ON N2G 1A3
519.745.4711 x 278
asteer@kwsymphony.on.ca
KWS Patron Services: 519.745.4711 | 888.745.4717 Subscribe Now
Please play your part today donate now!
Hi Adrienne,
Were you ever able to gather this information? I'm preparing for rollovers and was wondering the same questions.
Thanks,
Steve
This reminded me that I need to look for these issues as well, so I went digging...Looks like in the past I've used the following to track down base seats that weren't returned.Might help get you started.
Select a.* From t_sub_lineitem a
Join T_ORDER b ON b.order_no = a.order_no
Where a.sli_status = 3
and exists
(select * from T_SUB_LINEITEM where sli_status = 7 and a.order_no = order_no)
and b.tot_paid_amt = 0.00
and a.comp_code is null
Order By a.order_no