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

    • 5
    • 5
    • 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.

      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;

            [JSDSERVER-1247] Add Ability to Report on Issue Created Channel

            There are no comments yet on this issue.

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

                Created:
                Updated: