-
Suggestion
-
Resolution: Obsolete
-
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;
- is related to
-
JSDCLOUD-3203 Channel field not visible in a JQL research
- Closed
-
JSDSERVER-1247 Add Ability to Report on Issue Created Channel
- Gathering Interest
- relates to
-
JSDCLOUD-1903 JIRA created issues for a Service Desk should be searchable in JQL for request-channel-type
- Closed
-
JSDCLOUD-2344 Configure A Report To Show Channel Of Requests, Mail or Customer Portal
- Gathering Interest