How to get request name by id?

[Pavel Rusakov]

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_]

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

[Samuel Gatica _ServiceRocket_]

@Pavel Rusakov 

Also, check this doc:

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