Solved

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

Posted on 2008-10-08
6
609 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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
crm 2010 on premise 5 62
Need help with a query 3 46
Incremental load example 2 52
Dynamics CRM 2 30
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
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…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 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

11 Experts available now in Live!

Get 1:1 Help Now