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

Report Builder - Limiting query to return a certain number of results, how?

 Hello,


I'm actually using RTC/RDNG/RQM with their Safe configuration and using the Report Builder, I would like to produce some reports where the returned information is limited to a certain numbers of (work items. For example, listing the risks sorted on their (magnitude/)exposure and show only the top-3.

I was thinking of adding in the SQL statement things like LIMIT or playing with ROWNUM but it does not work. So how can I proceed to limit a list of for example 10 risks to display only 3 in report Builder?Thanks
Regards,
Olivier. 

0 votes



One answer

Permanent link

Olivier, I could not do it either. This looks like a good a idea for a new feature request that would let you make the choice in either the report or the dynamic filter. I guess for now you would have to show a minimum of 10.

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
× 12,019
× 481

Question asked: Nov 24 '17, 7:24 a.m.

Question was seen: 2,672 times

Last updated: Nov 24 '17, 10:17 a.m.

Confirmation Cancel Confirm