Get a list of 10 random cases from a JQL result

[Magdalena S]

Hi everyone,

I need to get a list of 10 randomly selected cases from a JQL result. Then, create a new ticket which would include a list of them and link this ticket to each of the 10 previously selected tickets. This would need to happen once a month so I am thinking to use an automation with a Scheduled trigger. I can’t use Zapier or a Script runner. 

Is it possible? Thanks in advance

[Jack Brickey]

Hi @Magdalena S , I don't understand the random requirement here. Do you really mean that you want to run some query that returns 10 random issues? Please note that JQL cannot achieve that requirement. It will return precisely what the query defines. You can certainly achieve the other aspect of your requirements, which is to run a JQL query within a scheduled trigger, followed by a new issue create and linking of this new issue to all of the results from the JQL query.

can you clarify the random aspect of your request?

[Magdalena S]

Thank you so much! 
Basically, a product owner wants to review 10 random tickets handled in the previous month. He doesn’t want them to be ordered by anything specific, just to meet a few JQL conditions and then randomly selected for his review. 

[Jack Brickey]

Thanks for that. As stated earlier JQL will not meet your needs here. Maybe you could do a JQL query to return the issues that meet your requirements such as done in the last month and then export the list to excel and apply some random selection algorithm. Short of that I would be looking at a third-party application solution. Of course you could always manually select from the list.