Creating JQL Filter for Dashboard Display

[alexei.g]

Hello Atlassian Community,

I hope this message finds you well.

I'm reaching out because I require assistance in forming a JQL query or filter that I intend to use for my dashboard. Specifically, I aim to display subtasks assigned to a particular individual along with their corresponding parent tasks.

The criteria I'm seeking to fulfill are as follows:

• Display subtasks assigned to a specific person.
• Include the parent tasks associated with these subtasks.

Could you please guide me on how to construct this query or filter using JQL?

Your prompt assistance in this matter would be greatly appreciated.

Thank you very much.

[Pramodh M]

Hi @alexei.g 

You could try searching for the issues based on factors such as Issue type and any custom field.

issuetype in ("Task", "Sub task") AND customfieldname = value

If you Scriptrunner, you could follow below reference

https://community.atlassian.com/t5/Jira-Software-questions/Find-parents-where-ALL-sub-tasks-meet-a-condition/qaq-p/1451653

Hope this helps

Thanks,
Pramodh