Hello,
We just went to v12 and updated to the standard ticket histories. I was trying to see of I could write a report that users could use to see the criteria of their old lists. I don't think just displaying the SQL is going to be helpful. Anybody have any code for parsing joins like in T_LIST criteria?
Thanks
Dean Yager
The Old Globe
Hi Dean.
Check under the Lists and Output Sets folder in List Manager and check out the List Criteria Definition Report. That might do the trick or at least point you in the right direction.
matt
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dean Yager Sent: Tuesday, April 14, 2015 2:42 PM To: Matt Hilgers Subject: [Tessitura Technical Forum] Anyone have SQL code for parsing the criteria field in T_LIST?
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
That is exactly what I wanted and it works perfect. Thanks for saving me the effort! It even works with the criteria that are not showing up in List Manager anymore. Exactly what I needed!