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; } } }

JIRA Select Random Tickets In Query

Michael Trimm

How do I select a random ticket out of a subquery set of results?

I want to be able to filter by story type and creation date to select a random ticket.

Thanks,

Michael

Accepted answers

Alexey Matveev

Hello,

Do you want to select a random issue via a JQL query? If so then it is not possible. JQL does not have such a function.

All comments

Alexey Matveev

Hello,

Do you want to select a random issue via a JQL query? If so then it is not possible. JQL does not have such a function.

Michael Trimm

Thanks for the quick reply, thats what I suspected. Looks like its time to use the API and post-process the data.

Thanks Alexey,

Michael

Tim Ward_y0ia82

in SQL you can do an order by newid() to do this. Pity there isn't a JQL equivalent.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-software