How to list Customer Request Types

Hello All,

I would like to know how to list all of the customer request types with their names and or Id's so that I can then set them using the automation tool.


I have a couple already, just from trial and error and know they follow the scheme of [PROJECTNAME]/[REQUEST NAME].


I don't care how I get them, whether it will be an API or through an SQL query.


Thank's in Advance.

1 answer

1 accepted

0 votes
Accepted answer

I have managed to find the answer myself, using a SQL Query:


SELECT [STRINGVALUE] FROM [jiradb].[jiraschema].[customfieldvalue] where [STRINGVALUE] like '%PROJECTNAME/%'

That only works if you have all of your Customer Request types in tickets.  If you have, for example 7 different Customer Request Types, but tickets exist for only three out of seven, you will have only values for those CRT's to which tickets are open.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,777 views 18 21
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you