9 years ago
Export a list of all DA 10 Cases
Export a list of all DA 10 Cases
Hi Trying to look for a simple SQL query that will provide Case name, Case number owner and its status etc from SQL.
Does anyone have such a simple SQL Que...
Are you looking for something like this?
SELECT tc.[Name] AS 'Case Name',
tc.CaseID AS 'Case Number',
tp.PrincipalName AS 'Owner'
FROM tblIntSearches tis
JOIN tblCase tc ON tc.CaseID = tis.CaseID
JOIN tblPrincipal tp ON tp.PrincipalID = tc.OwnerPrincipalID
GROUP BY tc.Name,tc.CaseID,tp.PrincipalName