Over the years, I have built a number of custom criteria in T_Keyword. As we prep for V. 16, I want to check if some of these custom criteria are still being used in lists. Is there a way either in the front end or , more likely, SQL that I can search of a specific criteria and find what list it is used in? I would also need to know when it was run and/or updated.
Anybody have any suggestions?
Seth Ghitelman,
In the way past I've done an exercise similar to what you are talking about. I no longer have access to the code I used for that project. However if I remember correctly, the trick was to look in the criteria column of T-List and look for the existence of t_keyword table values in those criteria. Sort of a messy business.
For extractions things appear to have changed since I've last looked at this. It appears that T_LIST_EXTRACTION is your key to much of this.
You should also take a look at output sets in the t_QUERY_*** tables.
If you get some code that is useful This may be helpful to others. Please share so we don't all have to re-invent the wheel.