Microsoft Dynamics 365 | Integration, Dataverse...

Subgrid calculation

(0) Share

Report

Posted on by Abhilash M abi

595

i'm trying to perform some calcuation on editable subgrid "QuestionGrid"... refer below code, there upto alert(count); i'm getting, while retrieving defectcritical column value it is showing getGrid null error...

function Demerits(executionContext) {

//subgrid unique name : "QuestionGrid"

var formContext = executionContext.getFormContext();

var gridContext = formContext.getControl("QuestionGrid");

var count = gridContext.getGrid().getTotalRecordCount();

console.log("Total Questions:"+count);

alert("Total Questions:"+count);

for(i = 0; i < count;i++)

{

//Critical values sum

var defectcritical = formContext.getControl("QuestionGrid").getGrid().getRows().get(i).getData().getEntity().getAttributes().get("systrent_defectcritical").getValue();//not getting this line

var criticalsum = criticalsum + defectcritical;

}

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Linn Zaw Win 3,407 on at

Like (0)

Report
Copy link

Link copied!

GridRow.getData client API is deprecated and it may not work well in Unified Interface.
formContext.getControl("QuestionGrid").getGrid().getRows().get(i).getData()

https://docs.microsoft.com/en-us/power-platform/important-changes-coming#:~:text=GridRow.getData

Please consider changing your script to call the Xrm.WebApi and calculate the summation of the defectcritical values from all child records. You can find the sample codes in the links below.

https://www.crmug.com/communities/community-home/digestviewer/viewthread?GroupId=1285&MessageKey=5c07b941-9c31-4990-afda-1a034a1329ee&CommunityKey=dc83c23b-ede0-4070-ae7a-dd90859148a6&tab=digestviewer&ReturnUrl=%2Fresources%2Fforum

https://www.inogic.com/blog/2018/01/dynamics-365-v9-0-xrm-webapi-crud-operations-part-1/

Was this reply helpful? Yes No
Abhilash M abi 595 on at

Like (0)

Report
Copy link

Link copied!

Upto alert i'm getting using deprecated methods only.. i tried using new methods but not getting anything...

Was this reply helpful? Yes No
Linn Zaw Win 3,407 on at

Like (0)

Report
Copy link

Link copied!

Before alert, the code that you used is gridContext.getGrid().getTotalRecordCount();

getTotalRecordCount is still supported and not deprecated.

https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/clientapi/reference/grids/grid/gettotalrecordcount

There is no new method to replace the deprecated GridRow.getData client API. Please consider changing your script to call the Xrm.WebApi as mentioned in the reply above.

Was this reply helpful? Yes No
Suggested answer

Linn Zaw Win 3,407 on at

Like (0)

Report
Copy link

Link copied!
Apparently, data property of GridRow object is the replacement for getData() method.

Here is the updated script of yours after replacing the deprecated methods. It should be working fine. But be aware that GridAttribute (.attributes.get("systrent_defectcritical").getValue() part) is only supported for editable grids according to the documentation and it may break on read-only grids in future upgrades.

function Demerits(executionContext) { var formContext = LZW.Xrm.Test.executionContext.getFormContext(); var gridContext = formContext.getControl("QuestionGrid"); var count = gridContext.getGrid().getTotalRecordCount(); var criticalsum = 0; for(var i = 0; i < count; i ) { var defectcritical = gridContext.getGrid().getRows().get(i).data.entity.attributes.get("systrent_defectcritical").getValue(); criticalsum = defectcritical; } Xrm.Navigation.openAlertDialog( { text: criticalsum }); }

Was this reply helpful? Yes No