It's all about the answers!

Ask a question

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


Dhanya Saseendran (8821121) | asked Jan 06 '11, 7:51 a.m.
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

2 answers



permanent link
Mohan K M (1111511) | answered Jan 13 '11, 5:29 a.m.
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

permanent link
Dhanya Saseendran (8821121) | answered Jan 16 '11, 11:56 p.m.
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

Your answer


Register or to post your answer.