• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 54 views
  • Users 0 members are here
Related

Anyone have SQL code for parsing the criteria field in T_LIST?

Dean Yager
$organization

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

Parents
  • $organization

    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.

Reply
  • $organization

    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.

Children
No Data