Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-1247

Add Ability to Report on Issue Created Channel

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • Reports
    • 3
    • 1
    • We collect Jira Service Desk feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for JIRA Service Desk Server. Using JIRA Service Desk Cloud? 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 - JSDSERVER-3203 Channel field not visible in a JQL research

          • Closed
          relates to

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

          • Closed

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

          • Closed

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

          • Closed
          mentioned in

          Page Loading...

          Activity

            People

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

              Dates

                Created:
                Updated:

                Backbone Issue Sync