It's all about the answers!

Ask a question

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


Dhanya Saseendran (8831521) | 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
Dhanya Saseendran (8831521) | 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

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

Your answer


Register or 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.