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

**URL:** <https://community.developer.atlassian.com/t/how-can-i-map-issue-number-and-request-type-in-service-desk/69886>\
**Category:** JSM Server\
**Created:** [May 31, 2023, 1:57pm UTC](https://community.developer.atlassian.com/t/how-can-i-map-issue-number-and-request-type-in-service-desk/69886 "2023-05-31T13:57:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sandvineet](https://avatars.discourse-cdn.com/v4/letter/s/f17d59/32.png) [@sandvineet](https://community.developer.atlassian.com/u/sandvineet)\
**Post date:** [May 31, 2023, 1:57pm UTC](https://community.developer.atlassian.com/t/how-can-i-map-issue-number-and-request-type-in-service-desk/69886/1 "2023-05-31T13:57:58Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![YufeiZuo](https://avatars.discourse-cdn.com/v4/letter/y/bc79bd/32.png) [@YufeiZuo](https://community.developer.atlassian.com/u/YufeiZuo)\
**Post date:** [June 2, 2023, 4:25am UTC](https://community.developer.atlassian.com/t/how-can-i-map-issue-number-and-request-type-in-service-desk/69886/2 "2023-06-02T04:25:22Z")

</div>

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.