Allow to limit the number of results returned by a query

[fschmidt]

Currently, it's not possible to limit the number of results returned by a specific query. It always returns as much elements as it matches, up to the overall limit (which would result in an exception view/error message rather than the number of results up to this limit).

For certain use cases it would be good to have the possibility to limit the number of results on a per query basis. Having such a feature, we could create queries, e.g. for diagrams, where just a certain number of results (10, 20, 50, ...) are used to generate something.

[jbates-2]

I would definitely entertain exposing options such as "TOP x" or "TOP x PERCENT", similar to SQL for this. Also give consideration for queries that run as a part of another construct, such as QBR, so that a QBR can potentially be limited in the amount of data that it returns. For a query that is used by a QBR, allow the QBR definition to override the value defined in the query itself. Default behavior for a QBR would be to return all results, regardless of what is defined in the query itself, to be consistent with existing behavior.

[KartikOak]

Hello Florian,

                     Assuming there exists a way to limit the number of Results shown when a Query is Run, what would you do with this incomplete information?

A Query-X typically returns a result of 1001 Items and going with the assumption that there exists an ability to limit this to show only 25 results! How or what is the user going to do with this incomplete data?

Would you expect this ability to be for Administrator Created Queries or for all users?

Thanks

Kartik Oak

[fschmidt]

Thanks for your answer and the question Kartik Oak‌!

The best thing would be, that there's is a way to order the returned results by a specific field in ascending or descending order. The result then could, e.g., used in a report or dashboard with the top 10 test failures or important requirements or whatever.

[mrump]

I really like this.

our use cases would be

- show TOP-10 Dangerous Risk Items (sorted by severity)

- show TOP-10 most pressing Risk Items (sorted by probability )

or less dramatic:

- next 3 Sprints/Iterations/Tasks  (sorted by start date)

As the other pointed out, this could really help getting along with the limits of the charts.

Just a imagine a "Riskmanager-Dashboard" that contains some Charts for the TOP 10 lists above + the usual link to the "All Risks" query.

Currently this only possible with Reports and JavaScript in the Browser.

[apost]

I would very much appreciate a top 10 type filter function. Currently for our risk analysis dashboard I have implemented a workaround where I display a report that is sized so that only 10 items appear but the user still needs to scroll to the top to ensure they are looking at the top issues.

[KartikOak]

The Refreshed Web UI provides Search & Query results in a paginated form. There is no immediate plan to allow the user to set the page size.