Difference between predefined and user saved searches in database.
How can I differentiate if the search is out of the box(predefined search) or user’s saved search ? Correct me if I’m wrong but I believe searches whose filtration criteria is not accessible “The Criteria for this search cannot be displayed” are known as predefined searches. I want to get the list of such searches from database, but I don’t seem to find any such column which could help me identify such searches.
Query that might help identify the solution.
SELECT * FROM QUERY q
LEFT JOIN SELECT_LIST S ON S.QUERY_ID = Q.ID
dooniedarkoo
Does this make sense ?
SELECT DISTINCT Q.* FROM QUERY q
WHERE IS_PUBLIC = 2