How to create a report that contains a list of request catalog items and the answers to their questions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2019 04:14 PM
I am trying to create a report to list all service catalog request items and the answers users provided when they order those items. I have checked the "sc_item_option" table. It contains the questions and answers to the "cart item" not the request item (RITM). In the "sc_item_option_mtom" table, it contains the request item (RITM) and the questions but no answers to the questions. I think I might have missed some information or don't know how to properly walk to the fields. If someone can share your insight that will be much appreciate!
Hugo
- Labels:
-
Service Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-21-2019 08:31 AM
Hi Reginabautista,
Could you please confirm which table you are using for the reporting? Also my purpose is to have the RITM and questions and answers to show in the report. I don't see there is any column for the answer in your pictures. Thank you!
Hugo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2019 04:15 PM
Hi Hugo, apologies for the reply. The table I have used is sc_request.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2019 07:02 AM
Hi Hugo, how are you getting on with the issue? If I have helped you resolve with this issue could you mark my answer as correct, please.
