How can I create a report that returns the lastest comment on each issue in a specific users inbox?

0 Likes

Problem:

How can I create a report that returns the lastest comment on each issue in a specific users inbox?

Resolution:

Such a query does not ship by default with SilkCentral Issue Manager, however this can be achieved by implementing an Advanced Query using the SQL below:

SELECT IM_Defect.InboxAssigned as "Assigned To", IM_Defect.ProjectID_fk as "Project ID", IM_Defect.DefectId as "Issue Number", Description as "Last Comment", IM_DefectHistory.DateLastMod as "Date Last Mod"

FROM IM_DefectHistory

INNER JOIN IM_Defect

ON IM_DefectHistory.IssueID_fk=IM_Defect.IssueID_pk

WHERE IM_DefectHistory.DateLastMod IN (SELECT MAX(IM_DefectHistory.DateLastMod) FROM IM_DefectHistory GROUP BY IssueID_fk) AND IM_Defect.ProjectID_fk = ${$PROJECTID} AND IM_Defect.InboxAssigned = "${InboxAssigned_0|Sarah -- QA|Inbox}"

Note the Query is project specific, i.e. it only applies to project in which it is currently defined.

Old KB# 30672
Comment List
Anonymous
Related Discussions
Recommended