SQL query to locate all external SQL queries

[Patty_Delmott]

We have been a 3 semester (term) university, but now are switching to 6 semesters.  I need to locate all external SQL queries that reference "term".  Is there a query for this?

Thanks!  Patty

[Mike_Saville]

Is this for custom queries or external autofills or external datasets?

[Patty_Delmott]

External Datasets on keywords, external datasets on Autofill Keyword sets.

[Mike_Saville · Accepted solution]

Keyword Dataset

select * from hsi.keyworddataset

where selectstring like '%term%'

Autofill Dataset

select * from hsi.keywordset

where selectstring like '%term%'