How to report on work items in JRS in certain state for certain time
I would like to report on number of work items in given state for certain time. Exactly he need to know the monthly number of workitems of type Defect in in few projects, hat was in status Open or In progress, in given period of time.
|
Accepted answer
It is possible using the following custom query for Data Warehouse data source:
SELECT T2.REFERENCE_ID
T1.REQUEST_STATUS,
T1.PREV_REQUEST_STATE,
T1.REC_DATETIME,
T1.CHANGE_DATE,
T1.DAYS_IN_STATE,
T1.REQUEST_NAME,
T1.PREV_REQUEST_STATUS,
T1.REQUEST_STATE,
T1.REQUEST_ID,
T1.PREV_REQUEST_STATE_ID,
T1.REQUEST_STATE_ID,
T1.PREV_REQUEST_STATUS_ID,
T1.REQUEST_STATUS_ID,
T1.REQUEST_STATE_HISTORY_ID,
T1.EXTERNAL_KEY1,
T1.EXTERNAL_KEY2,
T1.ISSOFTDELETED
FROM RIDW.VW_REQUEST_STATE_HISTORY T1
JOIN RIODS.REQUEST T2 ON T1.REQUEST_ID = T2.REQUEST_ID
WHERE (T1.ISSOFTDELETED = 0) AND
(T1.REQUEST_STATE_HISTORY_ID <> -1 AND T1.REQUEST_STATE_HISTORY_ID IS NOT NULL)
Ralph Schoon selected this answer as the correct answer
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.