JQL Query to search elements

Question

Hi Everyone,

We  have a parent element as "Sub Step" and that has a child element with "Epics". These epics are tagged under "Target PI" and have different applications tagged with efforts under the field of "App".

I have a requirement to find the PI forecast under "Sub Step" level and have the apps defined with efforts. But the current JIRA structure does not allows app efforts to be noted under "Sub step"

Is it feasible in current structure to extract data at sub step level which can give me list of all child epics for any sub step and then I can further modify it to extract application efforts.

I tried writing a JQL Query as below, however it is throwing errors. Not sure, if this is a correct way. I can successfully extract all the epics under a target PI. However, I cannot extract all the epics under sub step (Which is a parent  of epic).

I need a way I can extract all epics from sub step level and then capture the efforts by utilizing "App" field.

Not working -->>> issueFunction in epicsOf("project= xxx AND Target PI = abc).

Thanks for all your help!

Regards

Abhishek

Abhishek Ashok Dingre · Answer

hi @Walter Buggenhout

Thanks for your reply.. Much Appreciated.

I did some changes to your query as below

Project = "XYZ" and IssueType = "Epic new" and "Parent Sub-Step Summary" is not empty and "Target PI" = "ABC"

This gives me desired result. However, there is one more tweak we need to do. As the result is displayed at epic level. I am having multiple entries for a parent (Which is my sub step).

Reason - One Sub step can have multiple epics and each epic will have their distinct application efforts

Is there a way in JQL I can restrict the display to one single entry for multiple epics(that single entry will collate all epic efforts).

I hope, I am able to clarify the issue.

Thanks again for all your help!

Regards

Abhishek

Walter Buggenhout · Answer

Hi @Abhishek Ashok Dingre,

I am having some difficulty visualising your issue hierarchy from the description. But I can quite confidently say that issuefunction in EpicsOf() has a different purpose than what you are trying to achieve: it will try to return a list of epics connected to issues at the story level.

You may come a lot closer to the desired result with a query like this:

Project = xxx and IssueType = Epic and "Parent Link" is not empty
and "Target PI" = ABC

I am not 100% sure about the parent link as it's been a while since I last had a Data Center instance in front of me, but the idea is that you check for a hierarchical link to the level above epics being there. If the only issue type in your hierarchy above Epic is Sub Step, then using that principle should be sufficient to get the desired result.

Hope this helps!