cancel
Showing results for 
Search instead for 
Did you mean: 

Discovery Accelerator - find who was in a search

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello all,

I need to set Legal hold on case where specific people were targeted. As I have 100's of cases, and no overview which case is for who, can I somehow get the information from SQL?

I am looking for a query which would return Case-ID, and the content of the To/From search field (i.e. the Search criteria)

Is that possible?

Does anyone have such a query?

Much obliged!

Regards. Gertjan
1 ACCEPTED SOLUTION

Accepted Solutions

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

Found it (more or less). Run against Customer Database.

SELECT [SearchID]
      ,[CaseID]
      ,[Name]
      ,[Description]
      ,[NativeQuery]
      ,[NativeLegacyQuery]

  FROM tblIntSearches

YOu can then use the CaseId to find the case name:

Select CaseId, Name from tblcase where caseid = xx

Regards. Gertjan

View solution in original post

1 REPLY 1

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

Found it (more or less). Run against Customer Database.

SELECT [SearchID]
      ,[CaseID]
      ,[Name]
      ,[Description]
      ,[NativeQuery]
      ,[NativeLegacyQuery]

  FROM tblIntSearches

YOu can then use the CaseId to find the case name:

Select CaseId, Name from tblcase where caseid = xx

Regards. Gertjan