Issue with Including Variables in DB View-Based Report (RITM/SC Task/Approval)

ravish2k
Tera Contributor

2 hours ago - last edited 2 hours ago

Hi everyone,

I need a quick bit of help. I’m trying to create a report using fields from Request Item, SC Task, and Sys Approval, along with variables from the Request Item.

I created a database view combining Request Item, SC Task, and Sys Approval, and it returns the correct data. However, when I create a report on this DB view and try to include variables, they are automatically removed.

Alternatively, when I build the report on SC Task, I’m able to include fields from Request Item, SC Task, and the variables—but the approval fields are missing.

 
 
 

report1.png

Could you please suggest the best approach to handle this?

 

Thanks,

Ravish

0 Helpfuls
  • 76 Views
1 REPLY 1

Tanushree Maiti
Tera Sage

an hour ago

Hi @ravish2k 

 

Go through this blog for the solution:Report on Item Variables in the Service Catalog with a Database View

 

To report on Variables, Approval fields, and Tasks, create a Database View specifically joining sc_item_option (options), sc_item_option_mtom (variable ownership), sc_req_item (items), and sysapproval_approver 

 

 

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin:
0 Helpfuls