Tip #913: Searching within attachments

Search inside

Recently on the Dynamics CRM Facebook group, Rana Potter asked if it was possible to search within attachments from CRM. The winning answer came from Niran Belliapa: If you are using Dynamics 365 Online and have the December 2016 update you can use the Relevance search feature. You’ll find search results for text in a document […]

Tip #766: Drop your full text index the supported way

As reported in the Dynamics forum, there are known issues with upgrading CRM On Premises to CRM 2016 SP1 if you have full-text indexing enabled. You will get the following error: System.Data.SqlClient.SqlException: Cannot drop index ‘cndx_PrimaryKey_OpportunityProduct’ because it enforces the full-text key for table or indexed view ‘OpportunityProductBase’. Various posts include SQL scripts to remove […]

Tip #695: Full text search and field length

Standard field length

If you are on CRM 2015 Update 0.1 or later, you can enable full text search and make the quick search in CRM perform faster. If you do this, there is one drawback of which you should be aware: you will not be able to modify the field length of any field set to be a […]