It's all about the answers!

Ask a question

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


Olivier Béghain (1081928) | asked Nov 24 '17, 7:24 a.m.

 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. 

One answer



permanent link
Rafik Jaouani (5.0k16) | answered Nov 24 '17, 10:17 a.m.
JAZZ DEVELOPER

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.

Your answer


Register or to post your answer.