Database view creation
-
- UpdatedAug 3, 2023
- 1 minute read
- Vancouver
- Table Administration
The Vancouver release is no longer supported. As such, the product documentation and release notes are provided for informational purposes only, and will not be updated.
Create a database view to join tables. You can then create a report based on the database view.
Use the Database Views module to create a database view that joins tables to create a pseudo-table that combines data from each table in the view. You can create a report on this data by adding the database view as a table in a report. Accessing the database view does not require database access.
Related Content
- Displaying function results in a database view
Enhance the display of a database view by adding a function field to the output to display function results.
- Use disjunctions in complex queries
ServiceNow performs conjunction statements before disjunction statements in a query.
- Database views in the base system
Certain views are included in the base system with the Database Views and Database Views for Service Management plugins.