Friday, January 31, 2020
Sort on Related Column in a View
When we create a view, We can configure the sort but the sorting is available only for the columns which are a part of the entity on which the view is created.
Eg: In the active accounts view, there is a column " Email" which is a field from Contact Entity. If we see the columns available for sorting we cannot see Email.
However, in case you want to sort on a column from the related entity we can do it using the view designer and Fetch Xml builder tools from the XRM Toolbox.
On load of My active accounts, the default sort is on Account Name
Open View Designer on XRM Toolbox
Click on Edit Query to open Fetch XML Builder
We can see the order attribute is on name
Now, we can edit and add order attribute to emailaddress1
After you click on Return FetchXML, you will return back to view designer. Then click on edit XML and remove the disable sorting on the attribute.
You can now save and Publish.
The View My active accounts will be by default sorted by email address in ascending order.
Introduction: When your CRM and DocuSign are not connected, yet you wish to automate Closing Quote and saving your file in SharePoint, yo...
Introduction: In this post I plan to walk you through some concepts and functional aspects of CRM module of Dynamics 365. We will loo...
Introduction: This blog give the steps to access Recycle Bin of SharePoint using Microsoft Flows. Steps: In Actions, select &qu...
Introduction: In this post, we will read about solutions,Components and Import-Export of solutions in Dynamics CRM. Also we will see...