cancel
Showing results for 
Search instead for 
Did you mean: 

Accpeted Searches

pjglick
Level 4

Is there a way to see what the search crirteria was for an accepted search?

 

Thanks

2 REPLIES 2

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

ASalmon
Level 5
Partner Accredited

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.