Dynamics CRM removes an entity from an Advanced Find list that is not visible

sometimes we don't need to show an entity to a general user such as configuring entities, but this type of entity sometimes needs to be read to the general user, and the hidden comparison on the Sitemap is easier to configure under the tools. In fact, this step is generally possible but some customer requirements are relatively fine, not allowed in the advanced search to see the entity, how to do it, this is what I want to say.

Finding a variety of data will find that there are no open settings to let the entity in the Advanced Find does not display, it is a different point, here in the case of the customer entity, the default is to see the customer entity, such as

Then execute the following SQL in the business database, the name of the entity you want to remove.

Update metadataschema.entity Set isvalidforadvancedfind = 0 where Name = ' account '

IIS must be restarted after execution, otherwise it will not take effect, refresh the Advanced Find page after restarting, and you will see that the client entity is gone.

But this will have a hidden problem, compared to the following two pictures, this is I add subgrid on the Contact entity interface, you will find that the advanced Find in the Subgrid entity lookup has not seen the customer entity, It is not visible to the entities that have been removed when they are found in other similar entities. So there is a tradeoff to be taken when implementing this scenario.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Dynamics CRM removes an entity from an Advanced Find list that is not visible