Uploaded image for project: 'Advanced Roadmaps'
  1. Advanced Roadmaps
  2. JPOSERVER-1991

I would like to have a rest API call that returns the issues' details with their respective Portfolio Teams name.

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

    • JIRA feedback is collected from a number of different sources and is evaluated when planning the product roadmap. If you would like to know more about how JIRA Product Management uses customer input during the planning process, please see our post on Atlassian Answers.

      Problem Definition

      There is no rest API call to get an issue with its respective JIRA Portfolio team name.


      Suggested Solution

      Provide a rest API call to get the JPO's team name.


      Workaround

      If you currently run:

      https://localhost:8080/rest/api/2/issue/issue-key

      Part of the response will have:

      "customfield_15238":"882"
      


      To correlate the issue with its JPO custom field, you have to:

      check that custom field 15238 is the Teams (com.atlassian.teams:rm-teams-custom-field-team) custom field in the database by running the below query

      SELECT * FROM customfield WHERE id = 15238;
      


      to match the id from the rest API call to the team's field name, you have to query the AO_82B313_TEAM table as shown below:

      SELECT id, title FROM AO_82B313_TEAM where id = {take the id from the rest api call, in the below example "882"}
      


      To summarize, to correlate an issue with its respective JPO team currently you have to:

      1. run the rest API call
      2. parse its output
      3. take the id and then run the above select statement in order get the team's name


              Unassigned Unassigned
              ecasuscelli Esteban Casuscelli
              Archiver:
              atibrewal@atlassian.com Aakrity Tibrewal

                Created:
                Updated:
                Resolved:
                Archived: