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

[sandvineet]

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

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

None.  You should not be reading the database for this data, it's not supportable or going to work in the long term.