Solved

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

Posted on 2008-10-08
6
610 Views
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?

Thks,

JBS
0
Comment
Question by:jeebee75
6 Comments
 
LVL 15

Expert Comment

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

Direct Update of the database isn't supported.
0
 

Author Comment

by:jeebee75
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.

Regards,

JBS
0
 
LVL 11

Expert Comment

by:rakeshAgarwal
ID: 22668884
Hi  

  This is stored in attribute table  as Display mask  with value '402653184'  for  not searchable  and
'469762048'  for searchable
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 11

Expert Comment

by:rakeshAgarwal
ID: 22668900
This is stored in attribute table  for Displaymask

0
 
LVL 4

Accepted Solution

by:
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.
0
 

Author Comment

by:jeebee75
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.
Thks,

JBS
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

813 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now