It's all about the answers!

Ask a question

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

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


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

One answer

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

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.

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.