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.
Change the default search column on list view - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Change the default search column on list view
KB0820723

Change the default search column on list view


1835 Views Last updated : Apr 8, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

1. Go to any table (sys_user.list)
2. At the top of the table in the list view, find that the default search column can not be specified

Resolution

  • This is the default behavior and the UI is designed this way
    - The default search column gets set to the field which you use the "sort" for on the list view
    e.g. - If you sort on 'Name', the default column to search will get set as "Name"
    - This all gets set on "User Preference (sys_user_preference)"
    - What you can do is to go to have a default sys_user_preference record for all. Here is how you can do it:

    a) Go to sys_user_preference table
    b) Create a new record
    c) Fill in the fields as below:

    Name - sys_user.db.order (tablename.db.order)
    Value - sys_created_on. (column name you like to default on)
    Type - String
    System - Checked (true)
    d) Save the record

    - So , after doing this, any user logging in new will default on "sys_created_on"

    - if you want to remove the existing user's selection, search for all the user preference with the above Name and delete them before creation of the "System User Preference" in above steps.
  •  
  • Note: If user change the sort value, then it will get defaulted to what they selected again.



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?

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.