Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

I want to limit query output to the last single value

Arundev N B
Arundev N B
Contributor
September 20, 2021

Hi
While doing jira autoation, I want to limit result of below query to just last single latest created ticket number even though below query gives me 20 records. Any thoughts ?

Labels in (DRT) AND IssueType=Task AND createdDate >= startOfDay(-3)

Answer
Watch
Like # people like this
3364 views

1 answer

3 votes
Mehmet A _Bloompeak_
Mehmet A _Bloompeak_
Atlassian Partner
September 21, 2021

Hi @Arundev N B ,

There is no limiting functionality yet in Jira JQL. It is added as a feature request but not implemented https://jira.atlassian.com/browse/JRACLOUD-31384.

As an alternative, you can try appending "order by created"  into your jql and select the first one from the returned records.

View More Comments
Arundev N B
Arundev N B
Contributor
September 21, 2021

Thx. 

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events

    See all events