It's all about the answers!

Ask a question

Question on Jazz Advanced Data Set - BIRT


1
1
Bharath M (5465428) | asked Mar 09 '11, 6:26 a.m.
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



permanent link
Rafik Jaouani (5.0k16) | answered Sep 27 '12, 9:03 a.m.
JAZZ DEVELOPER

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 :)


permanent link
Rafik Jaouani (5.0k16) | answered Jul 06 '12, 12:59 p.m.
JAZZ DEVELOPER
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


Rafik Jaouani commented Aug 17 '12, 9:15 a.m.
JAZZ DEVELOPER

Hi Matthias, can you please describe in detail what does not work?


Matthias Buettgen commented Sep 27 '12, 5:00 a.m.

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.


Boris Fornaris commented Nov 23 '12, 6:47 a.m.

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


Rafik Jaouani commented Nov 23 '12, 9:21 a.m.
JAZZ DEVELOPER

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

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:
WI_ID IN param_1 doesn't work. ResultSet 0 records
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

permanent link
James Moody (3.3k24) | answered Mar 09 '11, 1:15 p.m.
JAZZ DEVELOPER
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

permanent link
Bharath M (5465428) | answered Mar 09 '11, 1:19 p.m.
Thanks James

-- Bharath

permanent link
Krzysztof Kaźmierczyk (7.4k373103) | answered Jul 06 '12, 4:02 a.m.
James - do you know when we can expect any doc to this?

permanent link
Cesar Sasaki (511285124) | answered Sep 26 '12, 6:17 p.m.
How do you use the parameters in an "Jazz Advance Data Set" ?
For example

WI_TYPE = 'DEFECT' AND  STATE_NAME ='PARAMETER'

?

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.