Sorting data in a Jazz Data Set for a BIRT report..
Is there a away to sort data in a jazz dataset before a BIRT report is built from that data set. For Example: I would like to see the returned data set sorted by a Date/timestamp.
If this is not possible in the current version of RTC/Jazz can this feature be included in a future version? Thanks in advance... O. Frank |
3 answers
Is there a away to sort data in a jazz dataset before a BIRT report is built from that data set. For Example: I would like to see the returned data set sorted by a Date/timestamp. Hey Frank - you can sort in bits by using this script on your datasets beforeOpen script: queryString = this.queryText; queryString = queryString + " order by " + reportContext.getParameterValue("WI_ID") + " " + reportContext.getParameterValue("asc"); this.queryText = queryString ; or you can click the table in your layout and then click the sorting tab in the properties editor to sort the final result. |
I tried to modify this.queryText, but it seems do not affect the report what so ever.
Is there a away to sort data in a jazz dataset before a BIRT report is built from that data set. For Example: I would like to see the returned data set sorted by a Date/timestamp. Hey Frank - you can sort in bits by using this script on your datasets beforeOpen script: queryString = this.queryText; queryString = queryString + " order by " + reportContext.getParameterValue("WI_ID") + " " + reportContext.getParameterValue("asc"); this.queryText = queryString ; or you can click the table in your layout and then click the sorting tab in the properties editor to sort the final result. |
The Jazz Data Source does not support sorting. You would have to do the sort the data after fetching it.
The solution proposed above may only work for a JDBC Data Source that uses SQL. |
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.