Uploaded image for project: 'Jira Service Management Cloud'
  1. Jira Service Management Cloud
  2. JSDCLOUD-1247

Add Ability to Report on Issue Created Channel

    XMLWordPrintable

Details

    • 1

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      NOTE: This suggestion is for JIRA Service Desk Cloud. Using JIRA Service Desk Server? See the corresponding suggestion.

      In JIRA Service Desk, it is possible to view through which channel an issue was created. It would be useful to be able to report on which channel issues are being created.

      In the meantime, it's possible to retrieve this information directly from the Database only, with the following query:

      SELECT DISTINCT p.pkey, ep.json_value, COUNT(ep.json_value) FROM entity_property ep
	JOIN jiraissue ji ON ep.entity_id = ji.id
	JOIN project p ON p.id = ji.project
WHERE ep.property_key = 'request.channel.type'
GROUP BY ep.json_value, p.id;

      Attachments

        Issue Links

          is related to

          Suggestion - JSDCLOUD-3203 Channel field not visible in a JQL research

          • Closed

          Suggestion - JSDSERVER-1247 Add Ability to Report on Issue Created Channel

          • Gathering Interest
          relates to

          Suggestion - JSDCLOUD-1903 JIRA created issues for a Service Desk should be searchable in JQL for request-channel-type

          • Closed

          Suggestion - JSDCLOUD-2344 Configure A Report To Show Channel Of Requests, Mail or Customer Portal

          • Gathering Interest

          Activity

            People

              Unassigned Unassigned
              mfernandes@atlassian.com Matheus Fernandes
              Votes:
              9 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: