Customer experience | Sales, Customer Insights,...

UCI Subgrid getTotalRecordCount() returns 0 records

(0) Share

Report

Posted on by T.Koller

145

hi,

I'm using a little javascript to count the records in a subgrid.

the sdk has this function:

context.getFormContext().getControl("mysubgrid").getGrid().getTotalRecordCount()

this function returns always 0 if the subgrid is on another tab (which is not loaded, yet).

If i navigate to that tab, subgrid loads, and getTotalRecordCount() returns the right result.

Any ideas on that issue?

best regards

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

CU06121650-0 6 on at

Like (0)

Report

UCI Subgrid getTotalRecordCount() returns 0 records

I was trying to SHOW the section the subgrid was in if it contained at least one record, but getTotalRecordCount always returned zero. I fixed this by showing the section with the subgrid by default and HIDING it if there were no rows. Seems like if the grid isn't displayed then the rows in the grid aren't recognized. Thought I'd mention this since I'd only seen mention of the Tab being displayed by default and not the section.

Was this reply helpful? Yes No
Suggested answer

Aditya 260 on at

Like (0)

Report

RE: UCI Subgrid getTotalRecordCount() returns 0 records

Hi T.Koller,

If the below code is not working :-
var totsubgrid= formContext.getControl("mysubgrid").getGrid().getTotalRecordCount();

There is an alternative way to retrieve the subgid entity records which are associated with the current record :-

var recordId = formContext.data.entity.getId().replace(/\{|\}/g, "");
Xrm.WebApi.retrieveMultipleRecords("subgrid_entity", "?$select=field1,field2&$filter=_subgrid_entity_value eq " + recordId).then(function success(results) {
var totsubgrid = results.entities.length;

}, function (error) {
var message = "There was an error while trying to load the page. Try this action again. If the problem persists, contact your system administrator.";
var details = {
message: message,
details: message + "\r\n\r\n" + error.message
};
Xrm.Navigation.openErrorDialog(details);
});

Please mark the answer as verified if it is useful to you!!

Was this reply helpful? Yes No
T.Koller 145 on at

Like (0)

Report

RE: UCI Subgrid getTotalRecordCount() returns 0 records

sorry but this can't be by design. If they allow you to put a subgrid on any tab they have to ensure that the sdk works fine.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

RE: UCI Subgrid getTotalRecordCount() returns 0 records

Hi,

I think this is by design. CRM loads components on form in lazy loading scheme.

Not all components are loaded synchronously. It would be better if you keep your grid on default tab which is the first tab.

If found helpful, Please mark my answer verified.

Was this reply helpful? Yes No

Community site session details

UCI Subgrid getTotalRecordCount() returns 0 records

If found helpful, Please mark my answer verified.

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

UCI Subgrid getTotalRecordCount() returns 0 records

If found helpful, Please mark my answer verified.

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates