What is the database field of the "is searchable" setting of an attribute

Posted on 2008-10-08
Last Modified: 2012-06-21
What is the database field of the "is searchable" setting of an attribute?
is it possible to change it directly (update) without using the GUI?


Question by:jeebee75
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 15

Expert Comment

ID: 22667669
That is what determines if you can use it in Advanced Find.

Direct Update of the database isn't supported.

Author Comment

ID: 22667968
sorry I meant WHERE is the database field of the "is searchable" setting of an attribute?
i know that it's not supported but for other purpose I used this method and it works fine. I want to check on my development platform first.


LVL 11

Expert Comment

ID: 22668884

  This is stored in attribute table  as Display mask  with value '402653184'  for  not searchable  and
'469762048'  for searchable
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

LVL 11

Expert Comment

ID: 22668900
This is stored in attribute table  for Displaymask


Accepted Solution

gregowens earned 250 total points
ID: 22676534
The best way to update this attribute is to export the customization xml and find the
IsValidForAdvancedFind attribute and set it to 0 (false) or 1 (true) as required then reimport.
For more background on the database approach, see here.

Author Comment

ID: 22676561
That's a good idea indeed... I used that method to change the content of a picklist but didn't think of it for ths update.


Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Grid querry results 41 83
How can I exclude some wording in a like statement? 39 78
Sql query 107 88
Using this function 4 42
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit If you want to manage em…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question