LIVE_WORKITEM_CNT and STATE table joins in Jazz Data Source
Posted 07 January 2011 - 07:46 AM
Posted 21 January 2011 - 04:27 AM
Posted 21 January 2011 - 07:52 AM
Posted 25 January 2011 - 12:45 AM
Thanks for reply.
Actually, I need state_name for workitems, closed,reopened etc. So I created computed column for State_?d as http://www.ibm.com/d...art3/index.html document.
I could create the computed column but state records is very different each in STATE table. So I can not write expression for state_id the computed column. Expression must include like '_Efk74JK'+row["STATE_NAME"].This computed column matches the ID value in the state table. this '_Efk74JK' value is very different my state table in my Jazz Data Source.
I had the same problem. The computed colum which is Project area itemid + State_name was slightly different. The data in the State table, column state, was Project area itemid + "s" + State_name.
Please check what is the difference in your state table and modify the computed column. Then it should work.
Posted 26 January 2011 - 05:54 AM
Posted 27 January 2011 - 01:20 AM
Thank you very much Dhanya,I used Project area itemid + State_name I can get STATE_ID.
But now I have another problem that I create new workItem Query at WorkItems tab. I selected all status in status conditions (opened, closed etc)and field against and owned by. But there are very records in this query (query result includes 336 records)than BIRT report(query result includes 154 records) with same query.
I guess you might have to check with one of the row that didn't come out of the Birt query result and debug this. I have no clue why this would have happened.
Posted 27 January 2011 - 04:02 AM
Posted 01 February 2011 - 12:25 AM
I compare birt and rtc query count, Birt query didn't list children WIs that related with parent WI. So Birt WI's count appear less than RTC WI's count. But I dont know how I resolve.
I have not explored the portion of the children links.
You might search in this forum as to how to pull the details of the children also.
So that you will have the same count in both the queries.