Receiving a field from another space Jira

Questions & Answers
1

Hi

I have a table of issues from Project A. For each task, I need to:

  1. Get the value of the “Assignee” field;
  2. Find a task in Project B whose name matches this value (i.e., Project B has a task with a name similar to the value of the assignee field in Project A);
  3. Get the value of the “Due date” field from the found task in Project B and display it in the table.

Any ideas on how I can do this?

2

Any ideas on how I can interact with other projects?

3

Hi @sn1ffer

If both Projects are in the same Jira instance, you can achieve this with the following steps:

  1. Select both Projects to be imported into the same eazyBI account.
  2. In eazyBI, create a report with Issue dimension in Rows with the Issue level selected and use the Project dimension in Pages to filter the report by Project A.
  3. Add the Assignee dimension to Rows and select the User level to be displayed.
  4. Click on the header of the “Issues created” measure and apply Filter rows → “> 0”.
  5. Define a new measure in the Measures dimension with a formula like this (set the formatting to Date):
Filter(
  [Issue].[Project B].Children,
  NOT IsEmpty([Measures].[Issue due date])
  AND
  [Assignee].CurrentHierarchyMember.Name <> '(unassigned)'
  AND
  LCase([Issue].CurrentHierarchyMember.Name) MATCHES '.*' || LCase([Assignee].CurrentHierarchyMember.Name) || '.*'
).Item(0).GetDate('Due date')

​Let me know if this fits your use case or if you have any additional questions on this!

​Best regards,

Nauris

4

Good afternoon, thank you for your help, however, I followed all the steps written, but this measure does not return anything. In the table, the column with this measure remains empty.

5

Hi @sn1ffer

Could you please send a screenshot of your report and also the report definition to support@eazybi.com ?

I’ll check what the issue could be.

Thanks!
Nauris