Answered by:
Where is the "IsValidForAdvancedFind" flag in the Metadatschema.Attribute table?

Question
-
Hi @all,
I need a list of all attributes of all entities which has the searchable flag set in a CRM 2011 onpremise instance.
If i remember correct, I have done this years ago under CRM 4.0 with a very simple SQL query, like:
select
IsValidForAdvancedFind,namefromAttribute
Group
byIsValidForAdvancedFind,name
But under CRM 2011 I doesn't found the "IsValidForAdvancedFind" in the "Attribute" table nor any other property which could be the field linked to the "Searchable" checkbox in customizing field form.
Does any now where the "searchable" property is now saved in the database?
regards
Matthias
Tuesday, January 14, 2014 8:43 AM
Answers
-
Hi Matthias,
Have a look at this blog, it should be what you're looking for: http://a-crm.blogspot.com.au/2009/08/get-list-of-searchable-attributes-from.html
Eric UNG [Senior Analyst Programmer :: Sydney, Australia]
- Marked as answer by Matthias Back Tuesday, January 14, 2014 3:46 PM
Tuesday, January 14, 2014 12:04 PM -
Hi
I have found the solution. the is valid for advanced Find is stored in the DisplayMask. see:
http://a-crm.blogspot.de/2009/08/get-list-of-searchable-attributes-from.html
- Marked as answer by Matthias Back Tuesday, January 14, 2014 12:33 PM
Tuesday, January 14, 2014 12:33 PM -
Hello,
You can find this column in the definition of each entity's attribute using the following SQL Query:
select * from MetadataSchema.Attribute where DisplayMask & 0x4000000 > 0 and EntityId = @entityId
Source : Get a list of searchable attributes from database
If you are looking for this information regarding standard entities, you can find an entitymetadata Excel File in the Dynamics CRM 2011 SDK, available here : http://www.microsoft.com/en-us/download/details.aspx?id=24004
You can then filter on the IsValidForAdvancedFin column.
Hope that helped!
- Edited by Thomas Canaple Tuesday, January 14, 2014 1:35 PM Formatting
- Marked as answer by Matthias Back Tuesday, January 14, 2014 3:46 PM
Tuesday, January 14, 2014 1:33 PM
All replies
-
Hi Matthias,
Have a look at this blog, it should be what you're looking for: http://a-crm.blogspot.com.au/2009/08/get-list-of-searchable-attributes-from.html
Eric UNG [Senior Analyst Programmer :: Sydney, Australia]
- Marked as answer by Matthias Back Tuesday, January 14, 2014 3:46 PM
Tuesday, January 14, 2014 12:04 PM -
Hi
I have found the solution. the is valid for advanced Find is stored in the DisplayMask. see:
http://a-crm.blogspot.de/2009/08/get-list-of-searchable-attributes-from.html
- Marked as answer by Matthias Back Tuesday, January 14, 2014 12:33 PM
Tuesday, January 14, 2014 12:33 PM -
Hello,
You can find this column in the definition of each entity's attribute using the following SQL Query:
select * from MetadataSchema.Attribute where DisplayMask & 0x4000000 > 0 and EntityId = @entityId
Source : Get a list of searchable attributes from database
If you are looking for this information regarding standard entities, you can find an entitymetadata Excel File in the Dynamics CRM 2011 SDK, available here : http://www.microsoft.com/en-us/download/details.aspx?id=24004
You can then filter on the IsValidForAdvancedFin column.
Hope that helped!
- Edited by Thomas Canaple Tuesday, January 14, 2014 1:35 PM Formatting
- Marked as answer by Matthias Back Tuesday, January 14, 2014 3:46 PM
Tuesday, January 14, 2014 1:33 PM