Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

1

1 vote



6 answers

Permanent link

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.

2 votes

Comments

Hi Rafik, now it works for me ... Thanks for the answer :)


Permanent link
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

1 vote

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

0 votes


Permanent link
Thanks James

-- Bharath

0 votes


Permanent link
James - do you know when we can expect any doc to this?

0 votes


Permanent link
How do you use the parameters in an "Jazz Advance Data Set" ?
For example

WI_TYPE = 'DEFECT' AND  STATE_NAME ='PARAMETER'

?

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Mar 09 '11, 6:26 a.m.

Question was seen: 9,353 times

Last updated: Nov 23 '12, 10:00 a.m.

Confirmation Cancel Confirm