Solved

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

Posted on 2008-10-08
6
612 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
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.  

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with SQL joins 9 53
CREATE DATABASE ENCRYPTION KEY 1 72
SSRS Problems 9 84
Restrict result set 1 39
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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

791 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