Add Ability to Report on Issue Created Channel

XMLWordPrintable

    • 1

      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;

              Assignee:
              Unassigned
              Reporter:
              Matheus Fernandes (Inactive)
              Votes:
              9 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: