Community
Q&A
Jira
Questions
Select Top Few Records from Filter.

Select Top Few Records from Filter.

I am writing query/filter in Jira as below

project = RGSSD AND status not in (closed) ORDER BY updated DESC

but this query is returning almost 250+ records but I want only top 15-20 updated records.

I tried using TOP constraint but its not supporting it. Can you please advise me on this please?

Thanks
Aniket

1 answer

1 accepted

0 votes

Answer accepted

You can do this by making your filter, saving it, then using that filter on a "filter results" dashboard gadget to limit the number of returned results.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thank you for the prompt response. :)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

I did it but anyhow all records are there, we are just limiting the view count on 1st page. I want this to be done in core query. is that possible?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

No, the filter results gadget is as close as it gets.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Okay...Thanks for your help Josh!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Christophe Duguet likes this

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS

Community showcase