I have created the database view in servicenow with four tables u_application, cmdb_ci_business_app,sys_audit and sys_dictionary
each with join condition as below:
u_application table- no condition-app as prefix
cmdb_ci_business_app table(business prefix)- app.u_application_name = business.sys_id(Added this condition beacuse in application table the application name refers to cmdb_ci_business_app)
sys_audit table(audit as prefix)- audit.documentkey = app.sys_id
sys_dictionary table(dictionary as prefix) -audit.fieldname = dictionary.element AND dictionary.name = 'u_application'
I created a report for this view by adding field names, old value,new value and fields which are required. I am able to view fields from u_application table but not from cmdb_ci_business_app table in the report, not sure of what is the issue.
I hope my conditions are correct. Please help here!
