It's all about the answers!

Ask a question

restrict WORKITEM_STATES table query output


Prasad Vasiraju (1548) | asked Mar 28 '14, 6:00 p.m.
retagged Apr 01 '14, 2:51 a.m. by Adam Wereszczynski (92811932)
A user is generating a BIRT report querying the WORKITEM_STATES table. He gets duplicate entries for defects on days  which the ETL data collection jobs ran twice. Is there a way to restrict the output on a per day basis, rather than per snapshot?

I have attached sample output which shows duplicate entries for March 28th.

Be the first one to answer this question!


Register or to post 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.