How to list Customer Request Types

[John Elnaugh]

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.

[John Elnaugh · Accepted solution]

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

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

[Andrew Bilukha]

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.

[Yadi]

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>

[Maria Kavoosi]

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"