Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Variable prefixes in View tables for Database views can not have uppercase characters - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Variable prefixes in View tables for Database views can not have uppercase characters
KB0727206

Variable prefixes in View tables for Database views can not have uppercase characters


2881 Views Last updated : Apr 7, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

Overview


This article explains another detail to take into consideration when creating a Database view: the Variable prefix field is case sensitive and uppercase characters will affect the outcome of the view. 

Variable prefix in a Database View


View Tables are created to specify the tables which will be part of the join(s) in a Database View.

A Variable prefix is added to the View table record in order to refer to this table in the Where clause conditions of the join(s).

We should only use lowercase characters in the Variable prefix. Using uppercase characters may prevent us from viewing the Database view in a list. The position of the uppercase character (whether it is the first character in the prefix, in the middle, or the very last character) is not relevant for this limitation.

Example


 

The image below provides an example of the correct way to assign a Variable prefix: inc 

If the Variable prefix would have been Inc, iNc, inC or any other value containing an uppercase character, the resulting list of the database view table would not display correctly.

 

Additional Information


Database views

Add a table to the database view 

 


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

Attachments

Attachments

  • Variable prefix in View table.png

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.