How to get request name by id?

Pavel Rusakov
Contributor
September 23, 2024

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?

 

1 answer

0 votes
Samuel Gatica (ServiceRocket)
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 24, 2024

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)
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 24, 2024
Like Pavel Rusakov likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events