Hello, my name is Patricio, and I have a question. Is it possible to obtain the information of the related jobs in a release?
A customer is asking me for this information and when I select the Release in a filter, it will show me this information in a dynamic table. I have tried but it does not appear.
Thank you very much for your help!
Patricio
Hi @Patricio_Gonzalez,
You reached out to us in an internal conversation. I will share my response with the community as well.
Unfortunately, eazyBI does not import the release “Related work” items. As related work can include release notes, analytics dashboards, designs, support documentation, business projects calendars, and more, what would be your idea of representing such data in eazyBI?
I see that Atlassian has a REST API endpoint to retrieve related work for each version - https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-project-versions/#api-rest-api-3-version-id-relatedwork-get. In theory, you can import additional data to the Fix Version dimension “Version” level members - a property containing information offered from the Atlassian REST API endpoint. Please see the information returned by the REST API below:
category - string
issueId - integer
relatedWorkId - string
title - string
url - string
Please look at our documentation page for more information on the additional data import - Additional data import into Jira Issues cube.
Let me know if you have any questions or suggestions.
Best,
Hi roberts,
Thank you very much for your answer it was clear to me how to get that information.
The situation is that the customer has a project called COSMO, and they maintain the following structure with the Releases:
Release
→ Related Jobs
. In this section they point to issue types from other projects (I am only interested in getting only the tickets associated to BUG and Steps to Production)
→ Stories
→ Subtasks
This structure is the one that led me to ask the question, since the customer’s goal is to select a Release, and show in dynamic tables all the structure mentioned above.
Thank you very much again
Patricio
Hi @Patricio_Gonzalez,
As you see from the Atlassian REST API structure, it only returns the issue ID, not the key or additional information. To retrieve some issue information, you would need an additional REST API call within the custom JavaScript code with getDocument()
- Data adjustments using JavaScript.
All that additional information would be available as a Fix Version dimension property - a string of data for each version, just like the “Version release date”. With some additional JavaScript code, you could retrieve the number of particular category type items as numeric measures.
I don’t have examples on retrieving exactly that data, but I encourage you to try importing the additional data.
Best,
Roberts // support@eazybi.com