Has anyone build a T_Keyword entry, for a list criteria for actual attendance to a specific Performance.
Did you do it with existing list criteria or did you create a custom view? If you have solved this one would you be willing to share a bit of SQL or a T-Keyword row that you use to set this up that would be very helpful.
How do you deal with the situation where a person buys 8 tickets and 4 had attended and 4 did not?
Saving the Attendance by Performance report to a list is a pretty good solution, as the parameters give you a lot of options for refining who you get (such as full attendance or partial attendance). But if you wanted to set up criteria to look at attendance, you could do it using the T_ORDER_SEAT_HIST table, which is where seat events are recorded each time a seat is marked as attended.
Event_Code is the column you’ll want to look at to identify seats that have been marked attended. Event codes are stored in TR_EVENT_CODE, which you can look at in System Tables. So I would probably set up a few new criteria, one for event code (with a dropdown populated with the event code for Attended), one for perf_no (you could set the dropdown up to display the performance names instead of IDs), and maybe price type if you wanted some extra filtering options. Then you could find everyone who had at least one ticket recorded as attended for a performance or everyone who has no tickets recorded as attended for a performance. You wouldn’t be able to get at people who used some but not all of their tickets without a manual edit to the code in your criteria set.
Please keep in mind that I haven’t tested any of this, so there could be some pieces of the puzzle I didn’t think about. Also keep in mind that when you add criteria that looks at a different table or view than the rest of your ticket criteria, you generally shouldn’t mix and match criteria from the two different sets and you generally won’t get the desired results. Finally, there might be some better ways to do this in v12 as we are adding the ability to add sub-entity criteria, which allow you to reference data that does not have a constituent ID on it if you can tie it back to a
parent entity that does have a constituent ID, which would allow you to use the seat history table instead and mix and match with your performance history criteria. We may even add a standard criteria element for attendance, though I can’t promise that.
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com