Question on Jazz Advanced Data Set - BIRT
Hi,
I was playing around with the new Advanced data set that is added for RTC 3.0 . Is there any documentation on how to use the filter feature for parameters while creating the data set. What syntax do we need to follow? Thanks in advance. Bharath |
6 answers
To use data set parameters with the Advanced Data Set Type, you will need to manually create the data set parameter and then use its identifier in the expression. E.g., if you have two data set parameters named param_1 and param_2, the following expression will work: WI_TYPE = param_1 AND STATE_NAME = param_2 The parameter identifiers must be on the right hand side of the operator. Comments
Matthias Buettgen
commented Sep 28 '12, 5:08 a.m.
Hi Rafik, now it works for me ... Thanks for the answer :)
|
The filter uses an SQL like syntax where the left hand side of the operator must be a column name and the right hand side can be either a constant or the name of a data set parameter. Here is an example:
WI_ID = 1 or (WI_ID = param_1 AND SUMMARY LiKe '%bla%') or WI_ID > 345 Comments
Matthias Buettgen
commented Aug 17 '12, 7:50 a.m.
Hi Rafik, I recently found this post and your answer as well. Currently we are thinking about using the Advanced Data Set. Therefore I'd like to know if it's possible to use it with parameters. I gave try but I didn't get it to work and I also try to modify the query text using Java Script. /Matthias Hi Matthias, can you please describe in detail what does not work?
Matthias Buettgen
commented Sep 27 '12, 5:00 a.m.
Hi Rafik,
Boris Fornaris
commented Nov 23 '12, 6:47 a.m.
Hello Rafik
Hi Boris, Try using the IN operator: WI_ID IN param_1 If you want to use the BIRT build-in JDBC Data Source, you will need to deploy the DB2 JDBC Driver in the BIRT drivers folder in the server. But I do not recommend that as your server will be open for users running arbitrary SQL against your DB.
Boris Fornaris
commented Nov 23 '12, 10:00 a.m.
Hi Rafik
Get to the point: Please, could you write the correct syntax in advanced dataset for the following behavior - If param_1 is null, shows all records - If param_1 is not null, only shows one workitem WI_ID=param_1 Im using WORKITEMS_SNAPSHOT as DataSource and LIVE_WORKITEM_CNT as Dataset I want to thank you for your help Best regards Boris
showing 5 of 6
show 1 more comments
|
Hi, Hi Bharath, I don't think there's any doc on this currently, although I think Rafik implemented some code assist that might help. We'll try to get some doc for this up on the wiki as soon as we can. james RTC Reports Team Lead |
|
James - do you know when we can expect any doc to this?
|
How do you use the parameters in an "Jazz Advance Data Set" ?
For example WI_TYPE = 'DEFECT' AND STATE_NAME ='PARAMETER' ? |
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.