How do I create this Filter - All Open Issues Assigned to Me with one or more Closed Sub-Tasks Reported By Me?

We're using Sub-Tasks in our workflow and need to now provide our users certain Filters, for example:

  • All Open Issues Assigned to Me with one or more Closed Sub-Tasks Reported By Me
  • All Open Issues that have one or more Open Sub-Tasks (pull up only the Open Sub-Tasks and not display the closed Sub-Tasks

5 answers

2 votes

You can do this using JQL tricks plugin (commerical). Something like this:

1: resolution = Unresolved and assignee = currentUser() and issue in subtask("resolution != Unresolved and reporter = currentUser()")

2: resolution = Unresolved and issue in subtask("resolution = Unresolved")

I'm sorry but these answers are INSANE.  You do not need to write code or use a plug-in to do this.

All you need to do is:

1. Select ISSUES from the top navigation.

2. Select MY OPEN ISSUE under FILTERS.

3. Go to the 4th filter.

4. On this page, select the forth dropdown filter titled Current User.

5. Type in the person you are looking for.

6. Use other filters to dig deeper. 

Thomas Schlegel Community Champion Sep 07, 2017

But that was not the question asked by Arthur. 

Where in your "sane" answer is the part with the "closed subtasks reported by me"?

Please do not abuse other answers as insane.

We use the free Craftforge JQL Functions Plugin plugin to run custom JQL.

For instance, to show Un-finished Issues or Sub-tasks in one quick-filter on Greenhopper:

status!=Closed or issue in parentIssuesFromQuery("issuetype in subtaskIssueTypes() AND status!=Closed ")

You can use MyPlate free add-on. It shows up all issues assigned to you.

0 votes

Thank you for bringing some measure of sanity to the discussion. Some people want to code EVERYTHING. I had one IT guy insist on copying files from one directory to another using the command prompt... wanted to smack him in the face

Thomas Schlegel Community Champion Sep 07, 2017

@Amine Aboufirass You're right, some people code nearly everything. I'm not one of these, but they're having fun in doing nearly everything with their keyboard. And that's ok. Noone gets hurt. But it is not insane.

Smacking someone in the face for helping you, that is something I would think about.  

Well...not literally... It was a joke you see. I am very grateful for what he did for me that day. I was just amused by how he had to do everything through the command line

Thomas Schlegel Community Champion Sep 07, 2017

Everything's good. Maybe I was a little bit too sensitive. Sorry for that. Maybe a sign of these times we're living in today.  

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,891 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot