Displaying function results in a database view
-
- UpdatedAug 3, 2023
- 1 minute read
- Vancouver
- Table Administration
Enhance the display of a database view by adding a function field to the output to display function results.
Function fields perform common database transformations and calculations on fields in the system. Function fields do not store any data, but rather display the results of a database query when the function is executed.
For example, you could identify incidents with ineffective descriptions of fewer than 10 characters by adding a function field that calculates the length of the Short description field.
Related Content
- Database view creation
Create a database view to join tables. You can then create a report based on the database view.
- 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.