Solved

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

Posted on 2008-10-08
6
620 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
[X]
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
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

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…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

691 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