How to get a report of values from the user table along with a value on a RITM form?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2022 05:27 AM
I need a report that includes a value from a catalog item I created as well as values from the user table. The value will be inputted by the user in a UI page variable. Can someone please guide me in the right direction? A step by step would really help. Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-10-2022 10:26 PM
Hi @simran3 ,
Its not clear from your question...what are the fields from user table are required.
I suggest you to create report using one of the following methods.
1. Using sc_item_option_mtom table. Here the values are stored along with the Parent RITM and the Question of catalog item. I have attached two screen shots. Using the RITM parent fields, you can get fields from user table for RITM Assigned to or RITM Requested For fields.
2. Second method is to create Database view for User, RITM and sc_item_option_mtom tables and create report on this database view.
If you find my reply as correct, hit the Thumb Icon and mark as Correct!
Thankyou,
Prithvi
