How to add 3 tables for database view for reporting purpose

Priya Singh 2 2
Tera Contributor

‎07-10-2024 08:18 AM

Hello Team,

Thank you team in advance!

Existing Report - Is on Policy Exception Table 

I have created one database view on Policy Exception table as below:

1.My first requirement is - We have a field called control objective on Policy Exception form which is referring to Control Objective table and I need to show one of Control objective field on this report which I am able to achieve

PriyaSingh22_0-1720623353567.pngPriyaSingh22_1-1720623452435.png

2.I have to show one of the field's values which is coming from Request Variable on Policy Exception form ( item) which user is selecting on the portal.

PriyaSingh22_2-1720623638540.png

PriyaSingh22_3-1720623918911.pngPriyaSingh22_4-1720623972246.png

Path - On Policy Exception Report under available : Question+ > Exception to Policy Request > It shows all request variables > (Field which is required to populated on the report question is Which guardrails? & name is azure_guardrails)

I am not able to find this field, even table is not showing any data.

@Anurag Tripathi  please advise.

 

0 Helpfuls
  • 256 Views
1 REPLY 1

Anushree Randad
ServiceNow Employee
ServiceNow Employee

‎07-29-2024 04:37 PM

Hi @Priya Singh 2 2,

If you have the fields added to the policy exception table, they should be available for your selection in the report. Is anything missing in above case? It's not very clear. Can you elaborate? 

 

Thanks,

Anushree

0 Helpfuls