SQL Query for Scheduled Search Result
Does anyone have a SQL Query that will return the results of each day's search. Name, Dept, Hits.Sampled, Duplicates?
Thanks!!
Hi Scott,
Please run following SQL query against CA Customer Database in SQL.
Select tis.Name,tc.Name AS 'Dept',tis.NumHits AS 'Hits',tis.SampleSize As '% sample', tis.NumDuplicates AS 'Duplicates',tis.RunDate,tis.Type
From tblIntSearches tis
Inner Join tblCase AS tc
ON tis.CaseID=tc.CaseID
Note : TYPEs
110
Immediate
111
Application Standard
112
Schedule
113
Schedule run
