nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I retrieve a particular amount of tickets ?

Charles Bovalis

Example: I need to find out the last 3 deployments for a particular service.

My JQL would look something like this:

project = GPROD AND issuetype = Logbook and "service name" = service-name
ORDER BY created DESC AND ( ?? display only 3 tickets ?? )

I am looking for the last part of this query - to be able to retrieve a particular number of tickets

Accepted answers

Bill Sheboy

Hi @Charles Bovalis

Short answer: no, that is not possible.

Longer answer: JQL is not a SQL, and so does not have most basic features of a SQL. Depending upon why/how you need the first 3 (or first N), you could create a dashboard with a issue filter gadget and try to limit the results or investigate marketplace addons for purchase to extend JQL features.

If you needed this for some type of reporting, you could use an automation rule to limit the result set, and send an email, post to Slack/Teams, etc. with just the first-N items.

Kind regards,
Bill

All comments

Bill Sheboy

Hi @Charles Bovalis

Short answer: no, that is not possible.

If you needed this for some type of reporting, you could use an automation rule to limit the result set, and send an email, post to Slack/Teams, etc. with just the first-N items.

Kind regards,
Bill

Jack Brickey_h10pa4

one question - what is significant about "the last three"? The only reason I ask is that if, for instance, you could leverage a date rather than the number of issues then you could work a date into your JQL.

Charles Bovalis

Thank you all for your feedbacks.

I eventually resorted to use Python for-loop along with a max_results counter variable to control how many answers to get.

Jack - the reason for getting the top 3 incidents of a particular service was because this is what they asked me to deliver. A service could potentially have several SEV incidents over time so they only wanted to see the last 3 incidents for a particular service.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud