I have moved into a role managing a V12 instance of Tessitura that has not moved over to the new standard ticket history table, and has not been customised to include owner/initiator/recipient roles. I'd be interested to see how other organisations who have maintained their custom ticket history tables have added the role data into the table, if anyone is willing to share their sql.
ThanksSarah
Unknown said: I have moved into a role managing a V12 instance of Tessitura that has not moved over to the new standard ticket history table, and has not been customised to include owner/initiator/recipient roles. I'd be interested to see how other organisations who have maintained their custom ticket history tables have added the role data into the table, if anyone is willing to share their sql.
I created new SSRS Ticket and Package history tabs here at the Guthrie, with corresponding custom tables, views, etc., for v12, which include O/I/R role data, as well as several columns specific to our legacy data. Happy to share; please contact me offline if interested.