How to create a report that contains a list of request catalog items and the answers to their questions

[Hugo7]

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

[sachin_namjoshi]

You need to create a database view joining RITM table,sc_item_option_mtom and  sc_item_option tables to requested item with questions and answers

Regards,

Sachin

[Hugo7]

Hi Sachin,

Your suggestion makes sense and I have thought about it. The problem is I didn't find the reference key from sc_item_option_mtom table and sc_item_option table. In sc_item_option table, it is cart item which is different than the RITM in sc_item_option_mtom. If you know how to set up the relation please let me know how you are doing this. Thanks!

Hugo

[sachin_namjoshi]

sc_req_item links to sc_item_option_mtom by the sc_req_item sys_id

sc_item_option_mtom links to sc_item_option by the sc_item_option.sys_id

Hope this helps.

Regards,

Sachin

[reginabautista]

Hi Hugo

You could report on variable responses by clicking on "Choose Column", scroll down to the very last item until you see "Questions". Click on the tree icon as shown below then select the catalog item you would like to access the variables from. You will then have access to the variables from there to be added to your report