How to construct JQL query that can give count of sub-tasks in a task or story?

[Sathya Bidyanand]

I want to assign card colors if a task or story does not have an original estimate value filled AND there were no sub-tasks.

Currently, in some cases, sub-task efforts roll up and show as estimates for the parent task/story. This is ok but I want to highlight where a parent does not have an estimate as well sub-tasks.

I am looking something like:

originalEstimate is EMPTY AND issue have sub-tasks

[Bill Sheboy]

Hi @Sathya Bidyanand  -- Welcome to the Atlassian Community!

I do not believe that is possible with out-of-the-box JQL.  You would need either a marketplace addon to enhance JQL (like ScriptRunner) or to use automation rules to count the subtasks and store that value in a custom field.

However, if you are showing subtasks on your board, a work-around would be:

• set card colors when originalEstimate IS EMPTY,
• display swimlanes by user story, and
• any issues without subtask will be listed in the bottom swimlane.  Just look there for the cards with your selected color.

Best regards,
Bill