Useful link to check latency Dynamics CRM 2011/Dynamics CRM 2013

Please check-out the following blog from my old colleague, I found it really useful:

https://rajeevpentyala.wordpress.com/2014/04/15/check-network-performance-using-crm-diagnostics-page/

Configure Views for showing records under specific Business Process Stage : Dynamics CRM 2013

We had requirement for showing Views on Opportunity based on stages, e.g, Opportunity in Qualify stage view should only show Opportunities under Qualify stage. For this we implemented in following manner:

Go to Default public view of Opportunity under Settings->Customizations->Entity->Opportunity->Views:

clip_image002

Click Save as fill in the name as below:

clip_image004

Screen will appear as below:

clip_image005

Click on Edit Filter Criteria and select related entity Process Stage, select criteria as in below screenshot:

clip_image006

Click ok, Save and publish this opportunity, Go to Sales->Opportunity, View will display opportunity only under Qualify stage now:

clip_image008

Hope it helps!

Get Attribute Logical Name from Display Name: CRM 2011 and CRM 2013 On-Premise\IFD using query

Recently wanted to get logical names of 25 columns at one go. Business analyst provided us with display names. One colleague of mine quickly told me about a workaround from database to read all at one go

Select ll.Label, Attr.LogicalName From LocalizedLabelAsIfPublishedView ll

INNER JOIN Attribute attr

ON ll.ObjectId = attr.AttributeId

INNER JOIN EntityView ev ON ev.EntityId = attr.EntityId

WHERE ev.ObjectTypeCode = EntityTypeCode and ll.ObjectColumnName in (‘DisplayName1’,

‘DisplayName2’)