---
sourceDocument: Xanadu ServiceNow AI Platform Administration
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/platform-administration

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Work with database views

# Working with database views for reporting {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 7, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

A database view defines table joins for reporting purposes.

For example, a database view can join the Incident table to the Metric Definition and Metric
Instance tables. This view can be used to report on incident metrics and may include fields from
any of these three tables.

Several useful database views are installed with the Database View plugin and the Database
Views for Service Management plugin. These database views cover most metric reporting needs and
greatly reduce the need to define new ones.

Any user who can create a report can use database views as the report source, but ACLs on the underlying tables are honored. This means that the ACLs of the parent tables of those tables are also evaluated.  
Note:  
* The accumulated impact on performance grows as the number of tables that are included in the view and the number of records that those tables contain increases. To maximize the performance of the database view, ensure that the 'where' clauses that are defined in the database view are based on indexed fields.
* A database view is not treated like a custom table, so there is no licensing impact.
* Database view tables are not included in FTP exports.
* Database views evaluate the ACLs of the parent table of a table included in the database view.
{#c_DatabaseViews__ul_nd5_qwm_cqb}

## Limitations

* Database views cannot be created on tables that participate in table rotation.
* It is not possible to edit data in the database view output.
* Database view tables cannot be added as a data preserver in clone requests.
* You can reference a table or database view from a different application scope in a Table Name field. However, if the field belongs to a table that extends sys_metadata, the table or database view must belong to the same application scope as that table.

## ACLs and database views

You do not need to create ACLs on fields in the view. The system honors contextual ACLs (ACLs
with a condition or script) that exist on the underlying table. Non-contextual ACLs (ACLs with
only role checks) are still honored just as with previous releases.

To require explicit read ACLs
be added to the database views, set the glide.security.expander.view.legacy
property to true. On upgraded instances, add this system property and set
it to
true.

You can still create additional ACLs on the database views. These ACLs are evaluated last and
are always honored.

## Database view reserved words {#c_DatabaseViews__section_h5v_43w_x1b}

Using the terms may cause unintended or undesirable performance. For more information, see the
[MySQL reserved words document](https://dev.mysql.com/doc/refman/5.5/en/keywords.html).
* **[Database view creation](https://servicenow-prod.fluidtopics.net/a2KsLerbK3uXQvXwtKIIAg)**   
  Create a database view to join tables. You can then create a report based on the database view.
* **[Displaying function results in a database view](https://servicenow-prod.fluidtopics.net/kTnvPDax3tKT97CkQE7Xig)**   
  Enhance the display of a database view by adding a function field to the output to display function results.
* **[Using disjunctions in complex queries](https://servicenow-prod.fluidtopics.net/PKuvXfOJEsfJCBPafaFq3Q)**   
  ServiceNow performs conjunction (AND) statements before disjunction (OR) statements in a query.
* **[Database views in the base system](https://servicenow-prod.fluidtopics.net/1m0H~JIy87XpAgjHjRl20w)**   
  Certain views are included in the base system with the Database Views and Database Views for Service Management plugins.