Tuesday, October 27, 2015

Querying with no table lock

By default when you're querying the MSCRM database the transaction lock the data used by the query. If you're doing several parallel queries on the same data the locking mechanism can highly increase the data retrieval.
You can configure the query to not use the lock mechanism.

Thursday, October 22, 2015

Back to the CRM in french / en français

Hello everyone, as you may know I'm French therefore I decided to create a french version of my blog !
If you're interested go to Back to the CRM FR.

Wednesday, October 21, 2015

Show N:N relationship in Advanced Find

You have a many to many relationship between two entities A and B but you can't see it in the Advanced Find ?
Here I'll show you how to display it.

First of all, if you are in CRM 2015 open the relationship and ensure the Searchable attribute is set to Yes.
Then, the related entity's Display Option must not set on Do not Display but on Custom Label or Use Plural Names.
For exemple if you are on the entity A and you want to display the N:N relationship with entity B, you must set entity B's Display Option to Custom Label or Use Plural Names. And vice versa.
Edit Relationship Dialog

Publish your customizations and... tadam ! you see in the Advanced Find the relationship.
Advanced Find

Great Scott !!