Accpeted Searches
Is there a way to see what the search crirteria was for an accepted search?
Thanks
Forum Discussion
Something like this would work, you would want to look in the NativeQuery, NativeLegacyQuery columns.
SELECT SearchID,
CaseID,
NumHits,
PrincipalName AS ModifiedBy,
tblIntSearches.Name AS SearchName,
tblIntSearches.ModifiedDate AS DateModified,
CreateDate,
tblStatus.[Name] AS SearchType,
CreationType.[Name] AS CreationType,
SampleResultSize,
NativeQuery,
NativeLegacyQuery,
XMLText
FROM tblIntSearches
LEFT OUTER JOIN [tblPrincipal] ON tblIntSearches.[ModifiedByID] = tblPrincipal.[PrincipalID]
INNER JOIN [tblStatus] ON tblIntSearches.[Type] = tblStatus.[StatusID]
INNER JOIN [tblStatus] CreationType ON tblIntSearches.CreationType = CreationType.[StatusID]
WHERE tblIntSearches.[StatusID] = 858 AND PrincipalName IS NOT NULL
UNION ALL
SELECT TypeID AS SearchID,
tblAudit.CaseID,
NumHits,
PrincipalName AS ModifiedBy,
tblIntSearches.Name AS SearchName,
AuditDate AS DateModified,
CreateDate,
tblStatus.[Name] AS SearchType,
CreationType.[Name] AS CreationType,
SampleResultSize,
NativeQuery,
NativeLegacyQuery,
XMLText
FROM tblIntSearches
INNER JOIN tblAudit ON tblAudit.TypeID = tblintSearches.SearchID
AND tblIntSearches.StatusID = 858
AND tblAudit.AuditTypeID = 1052
LEFT OUTER JOIN [tblPrincipal] ON tblIntSearches.[CreatedByID] = tblPrincipal.[PrincipalID]
INNER JOIN [tblStatus] ON tblIntSearches.[Type] = tblStatus.[StatusID]
INNER JOIN [tblStatus] CreationType ON tblIntSearches.CreationType = CreationType.[StatusID]
ORDER BY CreateDate DESC
From the DA console make sure you slect the tick box to list searches in review (can't remember exact terminoligy) and then you should see the accepted search. You can now double click the listed search and see the settings used.
