Advanced Query for Board - parent IssueType

[Damon Gaylor]

I have a shared resource team that works on issues from multiple projects.  Currently, the board query is:

project = COM OR assignee in membersOf(commissions) OR issuetype = Commissions ORDER BY Rank ASC

This works fine except the subtasks will not display on the board unless it is assigned to a member of the team.  I think I need to add something like ..."or Parent IssueType (assignee in membersOf(commissions) OR issuetype = Commissions)

---

Anyone have any suggestions?

[Petter Gonçalves · Accepted solution]

Hello Damon,

In order to display the Sub-tasks of a specific issue-type in a JQL filter, the best option is to create a new sub-task issue type to commissions.

Adding a new Commission sub-task, you could transfer the sub-tasks of your project to the new Sub-issuetype. Supposing the name of the new issuetype is Sub-commissions, you would write the following filter:

project = COM OR assignee in membersOf(commissions) OR issuetype in (Commissions, Sub-commissions) ORDER BY Rank ASC

Another option would be to add a custom field that could only be configured for the sub-tasks linked to commissions:

project = COM OR assignee in membersOf(commissions) OR issuetype = Commissions and customfield = value ORDER BY Rank ASC

[Damon Gaylor]

Thank you Petterson.  Your answer isn't ideal, but it is probably the best thing I can do.  

I think I will take a different approach given our business.  My plan is to kind of reverse the current process:

• Create all issues for this team in their Commissions Project
• Add a custom field for 'customer' (only about 10 customers)
• Change the query for the other project team backlogs to include issues where the customer = their Id.
  • Since I only want to show in backlog and status, they don't need to have easy access to the subtasks

Thank you for your great response.

[Petter Gonçalves]

I'm glad to know you were able to find a different approach for your business case, Damon.

Have a nice week and please don't hesitate to contact the community again everytime you need.