cancel
Showing results for 
Search instead for 
Did you mean: 

Export a list of all DA 10 Cases

DNABD
Not applicable

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 ?

 

3 REPLIES 3

JimmyNeutron
Level 6
Partner Accredited

This might require some custom reporting to be set up. Drop me an email I can link you to the right people

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Benedeta1980
Level 2

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