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
Wow -- the criteria for dynamic lists is actually stored in SQL format? That would mean that the client application itself is parsing that SQL to display the criteria window when you edit an existing list. Fascinating!
Are you unable to go back and look at those criteria sets that referenced your old ticket history? Or is this really a matter of generating a report? If it's the first case, I would expect that you could bring back the T_KEYWORD rows and/or views/tables that you were using (in TEST, perhaps), in order to view the criteria in the standard window, and then distribute screenshots to your colleagues.
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!
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!