Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Need help in Report designing - BIRT-RTC for custom fields

Hi,

I need some help in getting report for custom fields in RTC.
The particular report that I am currently trying is
- finding difference between Reported date and responded date for an Incident.
Here Incident is a custom WorkItem. Reported date and responded date are custom fields.

The data looks like below in Live_WorkItem_CNT table
WI ID TIMESTAMP_KEY TIMESTAMP_VAL
1416 com.ibm.gbs.workitem.workItemType.incident.reporteddate Dec 22, 2010

1416 com.ibm.gbs.workitem.workItemType.incident.respondeddate Dec 22, 2010

There will be many rows like this with two rows per WI_ID
I want to create one row out of these pair like the below
WI_ID Responded date Reported date
1416 Dec 22, 2010 Dec 22, 2010

Thanks
Dhanya

0 votes



2 answers

Permanent link
You can achieve this by creating two Data Sets with each of them selecting an either field and later having a join Data set of them. Hope it helps

Hi,

I need some help in getting report for custom fields in RTC.
The particular report that I am currently trying is
- finding difference between Reported date and responded date for an Incident.
Here Incident is a custom WorkItem. Reported date and responded date are custom fields.

The data looks like below in Live_WorkItem_CNT table
WI ID TIMESTAMP_KEY TIMESTAMP_VAL
1416 com.ibm.gbs.workitem.workItemType.incident.reporteddate Dec 22, 2010

1416 com.ibm.gbs.workitem.workItemType.incident.respondeddate Dec 22, 2010

There will be many rows like this with two rows per WI_ID
I want to create one row out of these pair like the below
WI_ID Responded date Reported date
1416 Dec 22, 2010 Dec 22, 2010

Thanks
Dhanya

0 votes


Permanent link
Hi,

I got a solution of using the Group on WI_ID and aggregation on the dates using filter conditions on the Dates fields.

Thanks
Dhanya

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 11,035

Question asked: Jan 06 '11, 7:51 a.m.

Question was seen: 7,083 times

Last updated: Jan 06 '11, 7:51 a.m.

Confirmation Cancel Confirm