NoLock – to be set or not

NoLock – to be set or not

NoLock – what is that? NoLock is a QueryExpression property used to specify how a RetrieveMultiple request will behave. Take a look at MS documentation since I’m not used to rewrite someone else’s posts, CRM upgrade features and MS limited documentation. Long story short: NoLock property sets to TRUE looks at database record lock and waits […]

RollupField is not recalculating

RollupField is not recalculating

RollupField is not recalculating RollupField – yes, nice CRM >= 2015 feature. Theoretically a cure for all previous “manual” calculations. Of course it has some limitations but this post is not about that. MSDN documentation contains these informations anyway. Unfortunatelly I came across a major issue related with rollup field when it’s type is Money. When? […]

CRM database without Active Directory

CRM database without Active Directory

CRM database without Active Directory You may ask yourself now if for any reason you will have to use CRM database without access to Active Directory. And because I have written this post it means yes – it can happen, even very often 🙂 When? Some Clients for security reasons don’t give access to AD or […]

Linq LoadProperty method limits records for retrieving relations N:N – 5000

Linq LoadProperty method limits records for retrieving relations N:N – 5000

Linq LoadProperty Issue – Description Recently I had to fix some legacy code (one of the worst code I have ever seen) and improve requests performance. When reviewing the code everything looks fine. There was a OrganizationServiceContext generated by crmsvcutil. Because one of the property was N:N relation a LINQ LoadProperty method was used. Nevertheless business logic […]

Count total number of records – how to??

Count total number of records – how to??

Count total number of records – what is the issue How simple can that be to count total number of records – just use linq query using EntitySet object like the one below var contactCounter = new ServiceContext(_service).ContactSet.Select(item => item).Count(); and that’s it. But no – you will get an exception: Invalid ‘count’ condition. An entity member is […]

Entity name by object type code JavaScript

Entity name by object type code JavaScript

Entity name by object type code – what is the issue Recently I found myself in a situation where there was no Xrm.Page.data.entity object so getEnityName() could not be used. Yes, there are form where it’s not available 🙂 I thought, phi, piece of cake. I remembered that there is FormEditorWebService.asmx which has a GetEnityId() so […]

How to publish enity form in javascript

How to publish enity form in javascript

What for? Some time ago I had to create and customize ~20 entities. After editing form, saving, publishing and reloading over and over again I thought about creating custom button for publishing. Yeah – why not. But this functionality already exists Yes, that’s true. If anyone hasn’t check how does the built-in publish button works […]

Local to global option set conversion

Local to global option set conversion

When there is a need of converting local to global optionSet we can use https://xrmoptionsetconverter.codeplex.com/. Everything works fine until this customization needs to be exported to another environment on which local optionSet is already declared and filled with data. Why? While importing customization error occures: OptionSetId cannot be changed. EnumAttributeInfo.AttributeDescription.OptionSetId(xxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) != xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx; How does the tool really […]