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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.