Build filter to show assigned tickets which are ready to start

[Maximilian Dorr]

Hey together,

we are trying to find a way to filter for issues which are ready to start.

In detail: We have linked our issues using the "has to be done after"-function as well as "has to be done before".

Is there any way to build a filter which shows issues which are:

• assigned to a specific user AND
• have a status of != done AND
• where the previous linked issues has the status "done"

Use-Case: We have quite long issues-chains so I want to have an overview for my colleagues to see which issues are ready to start working on. And the requirement for "ready to start" is that the previous linked issue is done as the previous issues are a required input for the next linked issue.

[Alex Koxaras -Relational- · Accepted solution]

Hi @Maximilian Dorr 

What do you mean by previous linked issues has the status "done". You mean that you have an issue (ABC-1), which you linked (at some point) with another issue (e.g ABC-123). Later on and during the progress of the ABC-1, you unlink for some reason its relationship with ABC-123.

Now you want to provide some sort of report to your colleagues about the state of the relationship of these issues? Sorry, but either I'm missing something or it doesn't make any sense the way you handle the linking functionality. If you link an issue with another, then even if that link doesn't apply (say an issue blocks another), you leave it there for history.

[Maximilian Dorr]

Hi @Alex Koxaras -Relational-

thanks for your answer. No I don't want to unlink it at anytime. Let's take your example:

• ABC-1 "has to be done before" ABC-123

What I am looking for is some kind of a dashboard/filter to show that ABC-123 is ready to start as soon as ABC-1 has the status "done".

Automation could probably handle that but I want to build kind of a dashboard for my team where they can look for their assigned issues which are ready to start as the previous linked issues is "done."

Hope that helps
 

[Alex Koxaras -Relational-]

Thanx for the clarification @Maximilian Dorr . That makes more sense now. The "previous" word on linked issues is really confusing (at least to me).

This can't be done out of the box without an app, and still if you will do it with an app, it will not be "dynamic" per se. With scriptrunner enhanced JQL search you could do that (my JQL is not the one you wanted, but I've placed it here for educational purposes aaand to get results):

If you work with the above filter on Scriptrunner it's fine. It's all dynamic and such. But to use this filter in Jira, you have to save it as a filter. And when you open it on Jira then the above filter becomes:

Then you take the above filter and you place it on a dashboard. You have to keep in mind to sync your filters.

[Maximilian Dorr]

Thanks @Alex Koxaras -Relational- for the info. :)

[Hamza Chundrigar]

Hi @Maximilian Dorr 

• assigned to a specific user —> Jira’s inbuilt JQL can do this
• have a status of != done —> Jira’s inbuilt JQL can do this too

The part that’s not possible with Jira’s inbuilt vanilla JQL is this:

• where the previous linked issues has the status "done"

You will likely need an app that provides JQL extensions to accomplish what you’re looking for. The two apps that come to mind are JQL search extensions for Jira and ScriptRunner for Jira.

Regards,

Hamza

[Maximilian Dorr]

Hey @Hamza Chundrigar ,

thanks for your answer. Exactly what I thought. The first two bullet points I can - as you say - do with JQL but the third one was that I was looking for.

Maybe I'll have a look at these add-ons.

Best regards

Max