It's all about the answers!

Ask a question

How to report on work items in JRS in certain state for certain time


Krzysztof Kaźmierczyk (7.4k34997) | asked Sep 15 '16, 5:51 a.m.
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


permanent link
Krzysztof Kaźmierczyk (7.4k34997) | answered Sep 15 '16, 5:52 a.m.
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


Register or to post your answer.