Question on Jazz Advanced Data Set - BIRT
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.
WI_ID = 1 or (WI_ID = param_1 AND SUMMARY LiKe '%bla%') or WI_ID > 345
Comments
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?
Hi Rafik,
I apologize for my late response to your answer. Anyway I tried it in the following way:
e.g. : WI_ID = params["workItemId"]
and that doesn't work for me.
Hello Rafik
To tell you the truth, the simple data set doesn't work that way.
Simple data set works this way
WI_ID = param_1
- If param_1 is null, this clausule doesn't apply and returns all records
- If param_1 is not null, this clausule applies and returns only records WI_ID=param_1
How do I get this funtionality in Advanced Data Set?
I've been finding out on the internet and found this syntax for Birt DB2 JDBC driver, but it doesn't work on Jazz driver:
SELECT SERVICENAMET
from KR9_TBSM_SERVICE_STATUS
where SERVICENAMET = '?param_1?'
Best regards
Boris
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.
Hi Rafik
No, no, I don't want to use JDCB Data source. Maybe you don't understand me. I only saw that syntax used in Birt, not even in RTC, that's it.
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
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
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