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.