Query Formatted Setting
I have a query that when I try to delete is keep on telling me that it is attached to some document but doesn't tell me where. Is there anywhere on the database that I can find where all the formatted query is attached to which form..
Owen Slater replied
Formatted search definitions are held in the CSHS table in the company database.
The following query should list out the queries that are being used as formatted searches in the company:
select * from CSHS T0 inner join OUQR T1 on T0.QueryId = T1.IntrnalKey