DYNAMICS 365 HOW TO FORCE RECALCULATE ROLLUP FIELDS

In this quick Blog post, we will see how to force recalculate Rollup fields in JavaScript and C# using the below functions.

  • Recalculate Rollup field in JavaScript (for account entity)

    function reCalculateRollupField(entityPluralName, recordGuid, rollupFieldName) {
    recordGuid = recordGuid.replace("{", "").replace("}", "");
    var requestUrl = Xrm.Page.context.getClientUrl() + "/api/data/v9.0/CalculateRollupField(Target=@tid,FieldName=@fn)?@tid={'@odata.id':'" + entityPluralName + "(" + recordGuid + ")'}&@fn='" + rollupFieldName + "'";
    var HttpReq = new XMLHttpRequest();
    // Double Check the API URL
    HttpReq.open("GET", requestUrl, true);
    HttpReq.onreadystatechange = function () {
    if (this.readyState === 4) {
    HttpReq.onreadystatechange = null;
    if (this.status === 200) {
    var results = JSON.parse(this.response);
    }
    else {
    Xrm.Utility.alertDialog(this.statusText);
    }
    }
    };
    HttpReq.send(JSON.stringify({}));
    }

  • Recalculate Rollup field in C# (for account entity)

    public void RecalculateRollupField(Guid accountGuid, string rollupFieldName)
    {
    CalculateRollupFieldRequest request = new CalculateRollupFieldRequest
    {
    Target = new EntityReference(Account.EntityLogicalName, accountGuid), //Record to be updated
    FieldName = rollupFieldName //Rollup Field Name
    };
    CalculateRollupFieldResponse response = (CalculateRollupFieldResponse)AdminService.Execute(request);
    }

Hope This Helps!

Comments

Post a Comment

Popular posts from this blog

DISABLE ALL FORM FIELDS IN DYNAMICS 365 USING JAVASCRIPT

Image
To make the form read-only in Dynamics 365 you have 3 options: changing record status to Inactive, Business rule, JavaScript. The purpose of this article is to know how to make all form fields disabled with JavaScript. Changing record status to Inactive might not very suitable for some cases where cascading rules might be applied to children records. On the other hand, even though it is a low code solution, using business rule to make all fields read-only will be very time consuming especially if a field is removed from the form or a new field is added to the form. However, using JavaScript will allow you to set all form fields to read-only dynamically with a small piece of code and you can do it based on a certain condition of an attribute value. Make read-only the whole fields of a form based on a certain condition
Read more

DYNAMICS 365 FILTER LOOKUP FIELD BASED ON N:N RELATIONSHIP

Image
How to filter a Lookup field based on a N:N relationship of a parent entity using JavaScript . To show you this, I will use the Account entity, the Contact entity, and a custom entity Conference . The contact entity has a N:1 relation with the account entity (lookup field) The contact entity has a N:1 relation with the conference entity (lookup field) The account entity has a N:N relation with the conference entity (sub-grid) I need to filter the conference lookup of the contact entity to list The conference records that are related to the contact parent account or The conference records that are not related to any account Based on the above conditions, the users will not be able to ch
Read more

DYNAMICS 365 HOW TO REFRESH SUBGRID IN JAVASCRIPT

Image
In other posts, we saw how to change the selected view of a subgrid and how to filter subgrid in JavaScript. In this post, we will see how to refresh a subgrid in JavaScript in order to show the latest records related to a parent record upon an action on the form or clicking a ribbon button. For the sake of this post, I will take the example of the cases subgrid related to an account record. Let's take the scenario, where an action is done on the client side that adds a case related to the account record. Therefore, the sub-grid should be automatically refreshed to reflect the updated list of cases. In order to do this, a JavaScript function should call the refresh() in order to refresh the subgrid and display the expected result. function refreshSubGrid(context) { var formContext = context.getFormContext();
Read more