How to get request name by id?

Question

Hello! I'm trying to find some way how to get customer request name by id which have format:

"it/h454jgk9-45gjggj-k56o-9gm9-5g9jgkfk".

I have the Script Runner if it help.

Maybe someone to know a way out?

Samuel Gatica _ServiceRocket_ · Answer

@Pavel Rusakov

Also, check this doc:

* How to find the Request Type of an issue using SQL query

Samuel Gatica _ServiceRocket_ · Answer

Hi @Pavel Rusakov

You can get the request type by project using this SQL.

SELECT p.pname as project_name, r."NAME" as request_type_name , (po."KEY" || '/' || r."KEY") AS request_type_key
FROM "AO_54307E_VIEWPORT" po, "AO_54307E_VIEWPORTFORM" r, project p
WHERE po."ID"=r."VIEWPORT_ID" AND po."PROJECT_ID"=p.id
ORDER BY p.pname

Hope this helps!

Best regards

Sam