- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-07-2019 08:27 PM
Hi there
New to the reporting side of ServiceNow.
Just wondering if there are reference guides for creating commonly used database views for Project reporting?
I have a number of reports to create ie Project Change Requests for specific Project Managers - Project Change Request doesnt have the column Project Manager, so have to join Project table - however even after reading docs - still not able to join tables. Thought maybe these commonly used joins already documented.
Thanks
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-07-2019 08:32 PM
Join the tables by referring the sys_id of one table(table A) to a field in another table(table B) which is reference field of the other one(table A)
Please follow the below link-
For exmaple- Please check the table- Incident Metric from Database views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-07-2019 08:32 PM
Join the tables by referring the sys_id of one table(table A) to a field in another table(table B) which is reference field of the other one(table A)
Please follow the below link-
For exmaple- Please check the table- Incident Metric from Database views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-07-2019 08:41 PM
You generally do not need to create database views in ServiceNow. You just dot-walk from the detail table up to the table you need the fields from. ServiceNow handles the join as needed.
For example, you would start on Project Change Request and dot-walk to the field Project.Project Manager
It requires admin access to create a database view but unless you have a doc id field (like in the metric_instance table) or you have multiple M2M tables, you shouldn't need one.
