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:


Click Save as fill in the name as below:


Screen will appear as below:


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


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


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’,