JIRA Select Random Tickets In Query

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

1 answer

0 votes

Answer accepted

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.

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

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

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

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

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