Show Display values for reference field on the report created on table sc_item_option_mtom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2023 07:01 AM
Hi All,
Once request is submitted, RITM will be created. I am generating report (in PDF format )for catalog item variables filled or selected when user will submit Service Request.
I have created report on table "sc_item_option_mtom". If the Question is reference field, then value is showing as sys_id in the report. How can we show display value instead of sys_id.
I also attached snapshot for reference field in the report.
Thanks in Advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2023 07:13 AM
mtom table stores the sys_id so it is showing sys_id in report.
can you follow below link to get the report? why exactly are you reporting on mtom table?
Raghav
MVP 2023
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2023 07:19 AM
Hi Raghav,
We have requirement whatever user has selected fields on the catalog item, we have to generate PDF of it.
So I have created report on "sc_item_option_mtom", because it will store fields in it.
I have created BR, I am passing RITM value in the report dynamically.
With help of Scheduled email, I generating this PDF and sending to the third party tool.
Thanks & regards,
Shantanu
