Sub-tasks Showing on Kanban Board Inconsistent

[Nicole Gosling]

Hello,

Similar questions have been posted.  I read them and can't find an answer that has worked for my situation. Sorry for the long post!

The company I work for is using Jira Software Data Center v9.4.20 for work management purposes.  Our Jira system is configured so an Epic (parent ticket) is created in the 'New Work Request' status when the customer submits a request.  When the Epic transitions to a particular status one or more Deliverables (child ticket) are automatically created in the applicable Jira project, and linked to the Epic.

Each deliverable will have zero to many linked sub-tasks.  Sub-tasks are like a checklist of activities that need to be completed (DONE status) before the Deliverable can be set to DONE status.  Once the Deliverable is DONE the Epic can transition to the next status in the workflow.

I am tasked with writing a board filter, for one of the support team, that retrieves their deliverables and it's link subtasks and displays them on the board grouped by Epic.  They board query appear to be retrieving the correct data however I have an issue with the way they are being displayed on the Kanban board.

For instance I have two deliverables, that were set up identically via an automation rule but are behaving differently. One displays the linked sub-task directly under the deliverable on the Kanban Board, while the other does not.  Refer to attachments for supporting information.

Board Configuration

Board Filter Query

project = CC AND ( ( issuetype in ("Project Deliverable", "Third Party Approval") AND "parent project type" in ("Urban Design", "Rural Design") AND (summary ~ "Customer Quote" OR summary ~ "Customer Acceptance and Forms" OR summary ~ "Design Package") ) OR key in subtasksOf('project = CC AND issuetype in ("Project Deliverable", "Third Party Approval") AND "parent project type" in ("Urban Design", "Rural Design") AND (summary ~ "Customer Quote" OR summary ~ "Customer Acceptance and Forms" OR summary ~ "Design Package")') OR issue in epicsOf("project = CC") ) ORDER BY Rank ASC

Swimlanes

Columns

Project Workflows

Thanks in advance for your insight.  Nicole :)

[John Izquierdo]

Hi @Nicole Gosling 

I may be wrong but I think you might be missing some open and close parentheses. Try the JQL filter below instead and see if it does the trick.

project = CC AND ((issuetype in ("Project Deliverable", "Third Party Approval") AND "parent project type" in ("Urban Design", "Rural Design") AND (summary ~ "Customer Quote" OR summary ~ "Customer Acceptance and Forms" OR summary ~ "Design Package")) OR (key in subtasksOf('project = CC AND issuetype in ("Project Deliverable", "Third Party Approval") AND "parent project type" in ("Urban Design", "Rural Design") AND (summary ~ "Customer Quote" OR summary ~ "Customer Acceptance and Forms" OR summary ~ "Design Package")')) OR (issue in epicsOf("project = CC")) ORDER BY Rank ASC 

I'm not too familiar with Software projects but do both boards use the same filter? If not, could you provide the filter for the board that is working? If they use the same filter let me know and I can spin up a quick Software project and test it out.

[Nicole Gosling]

Hi John,

Thanks for your quick response. I confirmed that both your query and mine return the same number of records. My issue isn't with retrieving the query results, but with how they are displayed on the Kanban board.

We have one board and one query. The problem is that some deliverables show their linked sub-tasks, while others do not. All our deliverables (stories) are created using Jira automation rules. For example, when an Epic moves from "New Work Request" status to "Verification and Schedule," it creates the same deliverable as other Epics that move to this status. Refer to examples 1 and 2 in the original post.

Thanks so much for your help, I really appreciate it. 

Nicole

[John Izquierdo]

@Nicole Gosling 

The deliverable that isn't displaying the subtask on the board, can you share a screenshot of it?