DYNAMICS 365 HOW TO FILTER SUBGRID IN JAVASCRIPT

In other posts, we saw how to change the selected view of a subgrid and how to refresh a subgrid in JavaScript.

In this post, I will talk about how to filter a subgrid using JavaScript in Dynamics 365 and display the needed records .

For the sake of this post, I will take the example of an account record and its related cases that are displayed in a sub-grid component.

Dynamics 365 filter subgrid

  1. In the account record, a field called Case Type that contains three options (Problem, Question, Request)
  2. Based on the case type selected, the sub-grid should be filtered and show the appropriate cases records
  3. To apply a filter on the subgrid, a fetchXml needs to be injected in the sub-grid and filtered based on the case type selected
  4. Therefore, go to the Case form and open Case Type field properties
  5. Under the Events tab, add the onchange event handler and call the function that will do the filter
  6. Save and Publish the form
As outlined in the following JavaScript function, you will be able to filter the Cases subgrid based on the user selection of the Case Type field.

function filterSubgrid(executionContext) {
var formContext = executionContext.getFormContext();
var caseType = formContext.getAttribute("cak_casetypecode").getValue();
var fetchXml = '<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">'
+ '<entity name="incident">'
+ '<attribute name="title" />'
+ '<attribute name="ticketnumber" />'
+ '<attribute name="caseorigincode" />'
+ '<order attribute="title" descending="false" />'
+ '<filter type="and">'
+ '<condition attribute="casetypecode" operator="eq" value="XXX" />'
+ '</filter>'
+ '</entity>'
+ '</fetch>';
if (caseType === 100000000) { // Problem
fetchXml = fetchXml.replace("XXX", "2");
}
else if (caseType === 100000001) { // Question
fetchXml = fetchXml.replace("XXX", "1");
}
else if (caseType === 100000002) { // Request
fetchXml = fetchXml.replace("XXX", "3");
}
formContext.getControl("cases").getGrid().setParameter("fetchXml", fetchXml);
formContext.ui.controls.get("cases").refresh();
}
  • Subgrid filtered based on Case Type = Problem
    Dynamics 365 filter subgrid 2

  • Subgrid filtered based on Case Type = Question
    Dynamics 365 filter subgrid 3

  • Subgrid filtered based on Case Type = Request
    Dynamics 365 filter subgrid 4

Bonus Tips:
  • The above code work in the classic interface, but not on the UCI; however it still not supported
  • There are multiple solutions on the web to make this working on the UCI, but, be careful in using them because they are unsupported
  • If you think this is an interesting thing to have and be supported in future releases, you can vote for the idea here


Hope This Helps!

Comments

Post a Comment

Popular posts from this blog

DYNAMICS 365 HOW TO HIDE RECENT RECORDS FOR LOOKUP FIELD IN UCI

Image
In UCI, a lot of behaviors have been changed comparing to the Classic Web Interface such as the tabs, BPF, and many others. Today, I will be talking about one of these behaviors which is the Recent Records in lookup fields. In a brief summary, the Recent Records feature will suggest the latest records that have been searched for, where the user can select one of them, and, the list of available records of the current view will then be displayed. This is a nice-to-have feature since it might help the users to speed up data entry. However, if the lookup has been filtered to display specific records, the Recent Records will not respect this filter and will keep showing records even is they should not. This scenario can lead to selecting a record by the user that is not allowed to be selected. Therefore, in this situation, it is better to hide the Recent Records t
Read more

SEARCH BY GUID IN DYNAMICS 365

Image
Is it possible to search for a CRM record using its GUID ? Well, NO it is not possible and YES it is possible!!! As always has been, it is not possible to search for a record by its guid in Advanced Find and in the Quick view search. However, in the model-driven app Edit filters functionality, it is possible to search for a record by its Guid. How it works, let's check the 3 different places where we can search for a records. Advanced Find search Using the Advanced find feature, you cannot put a GUID value to search for. You will directly receive an error notification eventhough when you download the fetchXml, the Guid of the record will be there. Quick view search Using the search box
Read more

SAVE FORM IN DYNAMICS 365 JAVASCRIPT

Image
In Dynamics 365, you may need to save a CRM form automatically in JavaScript upon a specific action on the form. In order to do that, the function formContext.data.save(saveOptions).then(successCallback, errorCallback); can be used to save the record asynchronously with callback functions to be executed after the save operation is completed. The following example will display a successful message if the save operation is completed, and a failure message if not. formContext.data.save(1).then( function () { alert("Successfully Saved!"); }, function () { alert("Failed while saving!"); });
Read more