how to get an aggregated count of weekly pull requests (from github integration) in jira structure

[Rajal Shah]

Hello - I am requesting help on could the all the pullrequest activity for this week in Jira structure and aggregate them in the hierarchy so .. stories or sub-tasks can have pull requests and they are aggregated for its parent Epic which is then aggregated to the parent Initiative.

Here are some formulas, I've tried unsuccessfully.

SIZE(issuelinks.filter($.type="merged").filter($.source=$))

//{{issue.development}}

//development[pullrequests].all

//if JQL {development[pullrequests].all} : development[pullrequests].all

[Stepan Kholodov _Tempo_]

Hello @Rajal Shah 

If the pull requests exist as issues in Jira, and they are connected to issues in the structure with links, then you can use a simpler formula like this:

SIZE(issuelinks.filter($.type="issue link type"))

the issue link type can be found at Jira settings | Issues | issue linking - you can map the link direction that appears on the Issue page with the type there.

I hope this helps. If you need further assistance here or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Rajal Shah]

ah.. I saw this example on browsing the web, but was the missing the context that pull requests has to exist as issues in Jira. Now the code made sense.. I had assumed that the development panel where the github integration data exists was available to query, which is not the case.

We don't have that setup of PR issue types.. but what I did instead was to push out the github PR changes to a jira field and used the built-in Aggregation over sub-items feature to get the value.  This resolved the request.