Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,294,005
Community Members
 
Community Events
165
Community Groups

Measuring issues that have a linked issue in another project matching a certain condition

Hi,

I'd like to measure in/outflow on issues in project A that have a link to project B where the linked issue matches a certain condition. I assume I need to import both projects and import the issue links as well, but how to continue from there, do you have an example setup?

 

2 answers

Sorry, the question was related to EazyBI where I want to setup a measurement as described. How can  I use the 'linkedissuesOf' function in htere?

Hi @Cornelia Richter ,

The function 'linkedissuesOf'​ is a part of the ScriptRunner app that works within Jira.
​The eazyBI reports use a separate eazyBI data cube that holds data imported from Jira.

Depending on your requirements, several options might be possible to get the same effect as 'linkedissuesOf'.

​If you want a static filter built into the measure - you might address the linked issues by their issue keys.

​The below sample code fragment creates a set of issues from project A that have linked issues in status To Do and where linked issues are created within the selected time period.
​This set of issues from A could be used in further calculations.

Filter(
--generating a set of A project issues
  DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
--actual filter
  Count(
 --Filtering the linked issues
    Filter(
 -- Generating set of linked issues
    [Issue].[Issue].GetMembersByKeys([Issue].[Issue].CurrentHierarchyMember.Get('All links')),
--conditions for linked issues - status To Do and created within current reporting period
    [Status].[Status].GetMemberNameByKey([Issue].[Issue].CurrentMember.Get('Status ID')) = "To Do"
     AND
    DateInPeriod([Issue].[Issue].CurrentMember.Get('Created at'), [Time].CurrentHierarchyMember)
   ) --end filter for linked issues
  ) --end count
  >0)


Alternatively, you might import the linked issue field dimension as a JavaScript calculated custom field. Then you might filter A issues based on the value of their linked B issue field through the page filter. 

​The best approach depends on your setup and requirements. If you get stuck - feel free to contact us directly.

​Regards,
​Oskars / support@eazyBI.com

0 votes

Hi @Cornelia Richter , What would the condition be? If understand the question correctly, you could use the 'linkedIssuesOf' function from ScriptRunner:

https://www.adaptavist.com/blog/top-10-most-commonly-used-jira-query-language-functions#linkedIssuesOf

Sorry,my question is related to eaziBI where I want to setup a measurement as described. How can I use the 'linkedIssuesOf' function in there?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

232 views 0 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you