Searching syntax for epic, its tasks and sub-tasks

[Piotr Ślęczkowski]

How to make most effectively a searching syntax, which will return complete epic, its tasks and their sub-tasks? I need to save this searching as a filter to get the Timespent report, where work log is saved on epic level, tasks level and sub-tasks level. I have no problem, when tasks level-1 are in the epic only, but I can't get the full range, when there are also sub-tasks. Thanks in advance for help.

[Michael Simmons · Accepted solution]

Hi Piotr,

On the assumption you are using cloud (as I am), this will return all items below an epic, including sub-tasks. Please let me know if this works or not.

project = "XXX" And "Epic Link" = XXX-123 OR parent in ("XXX-123") or parentEpic = "XXX-123" ORDER BY created DESC

Take care,

Michael

[Piotr Ślęczkowski]

Hi Michael, thank you for a quick response.

I found out in the meantime that "parent in ()" works, however "parentEpic" looks much better to me as in the former case I have to put issue code of every single task level-1, whereas I could put one value in "parentEpic=" getting the same result (I assume I could use either "parent in ()" or parentEpic=" as an equivalent).

Unfortunately "parentEpic" doesn't work in my Jira. I am given the message "Field 'parentEpic' does not exist or you do not have permission to view it." 

BR
Piotr

[Michael Simmons]

Hi @Piotr Ślęczkowski 

Are you using Data Center, Cloud, or Server? And, which version?

Michael

[Piotr Ślęczkowski]

Hi @Michael Simmons 

I am using Server version 8.17.1.

BR

Piotr