Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011 RU18 how query all fields in the database that are set to searchable? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am trying to determine all the fields that are set to searchable in the database. Can anyone assist with where this is stored in the database.

    Many thanks!

    Tuesday, December 16, 2014 5:05 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    I was finally able to find this. It is indeed in the metadataschema.attribute table in the Displaymask field.
    • Marked as answer by JenniferNHS Tuesday, December 16, 2014 10:38 PM
    Tuesday, December 16, 2014 10:38 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    I haven't tested, but I'm thinking it is on the table metadataschema.attribute.  I think it may be the visibletoplatform column.

    Jason Peterson

    Tuesday, December 16, 2014 8:47 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I was finally able to find this. It is indeed in the metadataschema.attribute table in the Displaymask field.
    • Marked as answer by JenniferNHS Tuesday, December 16, 2014 10:38 PM
    Tuesday, December 16, 2014 10:38 PM