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.
Hi Seth,
I can't answer your exact question but can tell you there are several migration & customization check reports that are available to BETA testers currently, that will help you identify the tables, views, keywords that are changing, so I'm sure that these reports will be available to all, in plenty of time for planning your upgrade.
Jo