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

  • Question

  • 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

  • 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

  • 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
  • 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