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.

    XMLWordPrintable

    Details

    • Feedback Policy:

      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.

      Description

      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


        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              ecasuscelli Esteban Casuscelli
              Votes:
              3 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: