Request channel type field in database schema

Filip Hanaczewski March 30, 2023

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?

1 answer

0 votes
Kai Becker
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 30, 2023

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

Filip Hanaczewski April 3, 2023

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events