Request channel type field in database schema

Question

Hello,
We are trying to improve our reporting and use a BI tool to do this.
One challenge we fell into is reporting on the request channel type.
We can not find that in the database scheme can you point us in the right direction on how to query the database to get a result showing channels that were used to submit an issue?

Filip Hanaczewski_tx2an4 · Answer

hmm, I was basing my assumptions on materials from the web, Request channel type was the field mentioned there the fact is we need to do it on the cloud version.
Is there a similar way do achieve this on the cloud version?

I still see it's possible to report on it in Jira Cloud by providing request-channel-type in JQL.

Kai Becker · Answer

Hi @Filip Hanaczewski

welcome to the community. I'm not quite sure what you are up to, as you selected cloud as deployment type but ask for a database field, which will only be accessible on Server/DC.

Anyways, to get the request channel type, you could base your request on the following:

SELECT p.pkey || '-' || ji.issuenum, 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'
AND p.pkey = 'HELP' AND ji.issuenum = '552';

HELP needs to be replaced with your project key and 552 with the number part from your issue key