where can I get the task with resolution 'Invalid'
One answer
I can only find RESOLUTION in the column in the LIVE_WORKITEM_CNT table of Work Items Snapshot RTC 3.0.1.1 and confirm by this article The DataWarehouse Snapshot Schemas.
I have not tried to check if this is the same in RTC version 4.
Comments
Nhi P Ta
Aug 02 '12, 10:01 a.m.Hi Zhen,
Can you please provide more context to this question? are trying to add resolution invalid to Task work item?
or you want to find resolution "invalid" in table for reporting purpose? If so are you using BIRT or RRDI.
I think with this additional information other on the forum can help you better.
Cheers
Zhen Lei
Aug 02 '12, 1:56 a.m.Thanks for your quick answer Nhi.
Now I'm using BIRT to do a report for 'Defect' workitems, from workitems snapshot, I can get STATE_NAME that is RESOLVED or NEW, however, you know that, for RESOLVED, there are resolutions like FIXED, INVALID, etc., and this is the data I'd like to use in my report.