Sub-tasks Showing on Kanban Board Inconsistent

Nicole Gosling_hjfw3r

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.