Create a BIRT report using a custom saved Work Item Query

Hi, I have a saved Work Items Query, which I created using the query designer in RTC.
I'd like to use the result of that query as a datasource to create a report using BIRT. How can it be done?

I watched the video tutorial that uses WORKITEMS_QUERY_RESULTS, but it's too basic. What if I want to create a Data Set with the columns of the result of the query? Is this possible?

I have RTC Client 3.0 iFix 1 and BIRT 3.7.1 integrated in Eclipse Indigo.

Please help, I have been trying to do this for a few days now with no luck. There's just such little information about this, and the samples and tutorials are really trivial.

I can do it by exporting the query results to a CSV file, and then using a Flat File Data Source, but that's not the idea.

Regards,

Gus

http://www.youtube.com/watch?v=NgkJs6Mk2IE

Hi Gus - whatch this video to see how you create a report which contains a dataset with results from a specific query. Instead of using an input parameter you can simply add a default parameter for the query ID to be run matching that of your custom query. then you can join what ever else you need from other snapshots to your results. Then what is the UUID of my custom query you ask ? Well in version 2.x no UUID was added to custom queries made. So what you need to do is create your custom query and share it. then find it in the process template xml and manually add a query id (look for some of the other queries for syntaxt for this) You may need to add it as a predefined query first (cant remember the order).
Finally use this query id you made up and put on your query in the process template in your birt report. Sounds tricky but should be fairly simple.

Thanks for the reply.
Before I started working with RTC and BIRT I thought that it would be a lot easier, and a straight forward procedure. But it turns out that it is not.
I don't know why, really, since the results of a query are exportable and BIRT takes in the format, why can't it all be done just inside RTC? -without linking snapshots to retrieve different values, that is.

Thanks for the reply.
Before I started working with RTC and BIRT I thought that it would be a lot easier, and a straight forward procedure. But it turns out that it is not.
I don't know why, really, since the results of a query are exportable and BIRT takes in the format, why can't it all be done just inside RTC? -without linking snapshots to retrieve different values, that is.

Hi Gus,

There is a number of reasons for this - first of all the idea of Jazz is that you can replace each component with that of your own choice making it an open platform. Eg use RTC, CQ or jira for defects, use jazz scm or something else, and for reports use BIRT, RRDI(comes for free) or Insight.
Secondly the data stored for reports are saved in a seperate database to keep heavy reports from having an impact to your production system. Imagine if it was taking results not from DW but from RTC's database then a detailed report might slow down the daily operations.
BIRT is open source and has it limitations. I can recommend you taking a look at RRDI which you can also download here at jazz.net

Both of the last replies have been very helpful. After working for a while with RTC I can se what you mean about it being generic and customizable.
I ve used the approach you suggested and it works fine.
Now I'm exploring the tables in the workitems snapshot to retrieve the rest of the information that I need. Like work item description and a few custom fields for each WI. I'm getting the hang of it.

This link is very useful also when working whith reports in RTC

https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas

Thanks for the reply.
Before I started working with RTC and BIRT I thought that it would be a lot easier, and a straight forward procedure. But it turns out that it is not.
I don't know why, really, since the results of a query are exportable and BIRT takes in the format, why can't it all be done just inside RTC? -without linking snapshots to retrieve different values, that is.

Hi Gus,

There is a number of reasons for this - first of all the idea of Jazz is that you can replace each component with that of your own choice making it an open platform. Eg use RTC, CQ or jira for defects, use jazz scm or something else, and for reports use BIRT, RRDI(comes for free) or Insight.
Secondly the data stored for reports are saved in a seperate database to keep heavy reports from having an impact to your production system. Imagine if it was taking results not from DW but from RTC's database then a detailed report might slow down the daily operations.
BIRT is open source and has it limitations. I can recommend you taking a look at RRDI which you can also download here at jazz.net :D :D

Hi,

Please share the post url and any guide for creating report from query.

Hi

Now only we can able to show id and summary. How do get other columns from query into report.


Thanks
Pugazh

Hi is it possible for the report to access custom attributes using this method?

Both of the last replies have been very helpful. After working for a while with RTC I can se what you mean about it being generic and customizable.
I ve used the approach you suggested and it works fine.
Now I'm exploring the tables in the workitems snapshot to retrieve the rest of the information that I need. Like work item description and a few custom fields for each WI. I'm getting the hang of it.

This link is very useful also when working whith reports in RTC

https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas

Thanks for the reply.
Before I started working with RTC and BIRT I thought that it would be a lot easier, and a straight forward procedure. But it turns out that it is not.
I don't know why, really, since the results of a query are exportable and BIRT takes in the format, why can't it all be done just inside RTC? -without linking snapshots to retrieve different values, that is.

Hi Gus,

There is a number of reasons for this - first of all the idea of Jazz is that you can replace each component with that of your own choice making it an open platform. Eg use RTC, CQ or jira for defects, use jazz scm or something else, and for reports use BIRT, RRDI(comes for free) or Insight.
Secondly the data stored for reports are saved in a seperate database to keep heavy reports from having an impact to your production system. Imagine if it was taking results not from DW but from RTC's database then a detailed report might slow down the daily operations.
BIRT is open source and has it limitations. I can recommend you taking a look at RRDI which you can also download here at jazz.net :D :D