I need inputs on JQL query for pulling all the child items for a specific field type added to parent

Question

I have a use case for which I am looking for some help.

I use Category (a multi-select field type) as one field in Issue types like EPIC, User story, Tasks, Bug, etc. We have EPIC > USER STORY > SUB-TASK & TASKS / BUG can be associated with Primary (or highest order work type which is EPIC)

I assign an option from CATEGORY say Type-A to an EPIC, then when I choose Category = TYPE-A, it should pull all the child items in the query and now JUST show me EPIC with Type-A assigned items only.

Does anyone have inputs on how I can pull the child items of EPIC with the category assigned with TYPE-A when I write a JQL?

Mayuresh Athalekar_yfnud4 · Answer

I know that Tempo structures have this option. However, I want to pull this data in the Tempo timesheet and there are limitations in tempo teams to use Jira fields for selection. So JQL is the only option that I left to my current understanding.

Are any Tempo timesheet experts here who can assist here? And this has to be done in reports of tempo timesheet.

Jason Waller · Answer

I'm not sure you can achieve this using JQL

Essentially you want to output children of parents (epics) based on a value that is only set on the parent

I'm not sure a JQL query is the best option here, I think this will require some automation to achieve

Mayuresh Athalekar_yfnud4 · Answer

Anyone either from fellow users or from Atlassian support can help here ?