How can I map issue number and request type in service desk

I can get details jiraissue number, summary, resolution and all using jiraissue, issuestatus and resolution table.
I can get request type and key, data separately using AO_54307E_VIEWPORTFORM and VIEWPORT_ID but how can I map with above result. which column I should use to map request type with issue number.

Thanks

Hi @sandvineet ,

The mapping between request type and issue ID is jiraissue.issuetype = AO_54307E_VIEWPORTFORM.ISSUE_TYPE_ID. You can get the project ID via AO_54307E_VIEWPORT.PROJECT_ID = jiraissue.project or AO_54307E_VIEWPORTFORM.VIEWPORT_ID = AO_54307E_VIEWPORT.ID.
Hope it helps!

Regards.

1 Like