nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

LIVE_WORKITEM_CNT and STATE table joins in Jazz Data Source

ydgr

Hi,

I can use RBD v7.5.1.5 and BIRT v2.3.2. I connect Jazz Data Source, with WORKITEMS_SNAPSHOT snapshot.I created two dataset that first data sets name is LIVE_WORKITEM_CNT and STATE. LIVE_WORKITEM_CNT table include WI_ID, SUMMARY, PROJECT_AREA_NAME, CONTRIBUTOR_NAME columns but I want to see STATE_NAME column in the same data set. STATE_NAME column is in the STATE table so I joined data sets LIVE_WORKITEM_CNT and STATE table using below document: http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part3/index.html (Table joins)

There are 196 records in my STATE table. So I can not add a computed column to the work items data set.

I hope, I can explain corret.
Thanks

Find more posts tagged with

Comments

Dhanya

Hi,

I did not understand your problem correctly.
Were you able to fetch the correct records from STATE table?
Were you able to created the computed column? If not why?
Thanks
Dhanya

ydgr

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.

Thanks again

Dhanya

<blockquote class='ipsBlockquote' data-author="'ydgr'" data-cid="72491" data-time="1295625122" data-date="21 January 2011 - 08:52 AM">
Thanks for reply. 
 
Actually, I need state_name for workitems, closed,reopened etc. So I created computed column for State_?d as <a class='bbc_url' href='http://www.ibm.com/d...art3/index.html'>http://www.ibm.com/d...art3/index.html</a> 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. 
 
Thanks again </blockquote>
 
Hi, 
 
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. 
Thanks 
Dhanya

ydgr

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.

Thanks.

Dhanya

<blockquote class='ipsBlockquote' data-author="'ydgr'" data-cid="72612" data-time="1296050093" data-date="26 January 2011 - 06:54 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. 
 
Thanks. </blockquote>
 
Hi, 
 
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. 
 
Thanks 
Dhanya

ydgr

Hi,

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.

Thanks

Dhanya

<blockquote class='ipsBlockquote' data-author="'ydgr'" data-cid="72661" data-time="1296129779" data-date="27 January 2011 - 05:02 AM">
Hi, 
 
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. 
 
Thanks </blockquote>
 
Hi, 
 
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. 
Thanks 
Dhanya

Dhanya

Hi,

Can you check this out
http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part2/index.html
This tells how to get the child and parent work items

Thanks
Dhanya