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 Query ?
Forum Discussion
3 Replies
Replies have been turned off for this discussion
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.PrincipalNameThis might require some custom reporting to be set up. Drop me an email I can link you to the right people
This one I just added the Status of the case:
SELECT tc.[Name] AS 'CaseID',
tc.CaseID AS 'CaseNumber',
tc.statusid ' CaseStatusID',
ts.name 'CaseStatus',
tp.PrincipalName AS 'Owner'
FROM tblIntSearches tis
JOIN tblCase tc ON tc.CaseID = tis.CaseID
JOIN tblPrincipal tp ON tp.PrincipalID = tc.OwnerPrincipalID
JOIN tblStatus ts ON tc.StatusID = ts.StatusID
GROUP BY tc.Name,tc.CaseID,tp.PrincipalName, tc.statusid, ts.name
