Please check-out the following blog from my old colleague, I found it really useful:
Day: April 24, 2014
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’,
‘DisplayName2’)