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

[Mayuresh Athalekar]

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]

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

[Jason Waller]

Just so I fully understand what you are asking 

Could you have multiple epics assigned to TYPE-A, if so do you want the child issues to be split by Epic?

[Mayuresh Athalekar]

It is possible that multiple EPICs will have Category with option TYPE-A assigned. Consider this use case, where a feature will have multiple EPICs through which a it will be delivered.

As of today, i want to pull the list of all work items under any EPIC assigned with category assigned with TYPE-A  even if child items of those EPICs have no category assigned.

[Jason Waller]

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]

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.