Limiting results of Filter

[Milan Brown]

Hi,

I'm trying to get create a filter that limits the result to the Top 5 ordered by rank. Something similiar to Select TOP 5 in SQL.

Any help would be greatly appreciated.

[Udo Brand · Accepted solution]

I don't think this is possible within a filter. But you can restrict on your dashboard in the filter list the number of results displayed. Together with your order by clause this should give you what you want.

[dleng]

This has been asked before here: https://answers.atlassian.com/questions/20653/jql-project-dnatest-and-rownum-10-how-to-use-rownum

Limit is not supported so far.

Also, not sure if this is helpful for you or not: https://confluence.atlassian.com/display/JIRA/Limiting+the+number+of+issues+returned+from+a+search+view+such+as+an+RSS+feed

[Milan Brown]

Thanks very much.