restrict WORKITEM_STATES table query output
Prasad Vasiraju (15●4●7)
| asked Mar 28 '14, 6:00 p.m.
retagged Apr 01 '14, 2:51 a.m. by Adam Wereszczynski (928●1●10●32)
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. |