nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

John Elnaugh

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

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

All comments

John Elnaugh

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

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

Andrew Bilukha_1gdw5z

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"