How to list Customer Request Types

John Elnaugh August 15, 2017

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.

3 answers

1 accepted

0 votes
Answer accepted
John Elnaugh August 16, 2017

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

 

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

Andrew Bilukha December 13, 2018

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.

1 vote
Yadi October 25, 2021

Not on the list, but to find request type id might help you with following step.

Open created ticket on desire customer request type, Export as xml then search for "Customer Request Type" you will found data-key right below customer request type

Ie:

<customfield id="customfield_XXXXX" key="com.atlassian.servicedesk:vp-origin">
<customfieldname>Customer Request Type</customfieldname>
<customfieldvalues>
<customfieldvalue data-key="abcd/f6897a86-3e59-4783-bba4-8672c74bd4a9"> Test Incident template </customfieldvalue>
</customfieldvalues>

0 votes
Maria Kavoosi January 1, 2023

in SQL:

 

SELECT A.NAME AS ProjectName,
A.ID AS ProjectID,
B.NAME AS CustomerRequestType,
B.ID AS CustomerRequestTypID
FROM
"AO_54307E_VIEWPORT" AS A
INNER JOIN "AO_54307E_VIEWPORTFORM" AS B
ON B.VIEWPORT_ID = A.ID
WHERE A.PROJECT_ID = "ProjectID"

Suggest an answer

Log in or Sign up to answer