web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Read all record from S...

Microsoft Dynamics CRM (Archived)

Read all record from Subgrid - using Javascript

(0) Share

Report

Report

Posted on by vijay12872

1,000

I have "loans" Sub Grid in form. In that grid i have 3 records. But i show 2 records in one page of that grid and show another 1 record in next page.

In loansGridTotalCount i got count as 3.

Inside of that for loop am trying to get rollNumber values. I got first two record's roll number value in rollNumber(variable).

If i try to get 3 rd record value i got the error.

var loansGridTotalCount = window.parent.Xrm.Page.getControl("Loans").getGrid().getTotalRecordCount();

for(var i=0;i<loansGridTotalCount ;i++)

{

recordId = window.parent.Xrm.Page.getControl("Loans").getGrid().getRows().get(response).getData().getEntity().getId();

var rowData = window.parent.Xrm.Page.getControl("Loans").getGrid().getRows().get(response).getData().getEntity().getAttributes();

var rollNumber = rowData.get("new_rollNumber").getValue();

}

How can I get all the records from all pages in subgrid ?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

Hi Vijay,

I don't think it is possible to get all the records from all the pages in sungrid.

stackoverflow.com/.../reading-all-records-of-a-subgrid-regardless-of-the-active-page-with-javascript-i

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

meenoo 7,316 on at

Like (0)

Report

Hi Vijay,

Try this:

var allRows = Xrm.Page.getControl("Loans").getGrid().getRows();

This returns a collection of every GridRow in the Grid.

Thank you.

Was this reply helpful? Yes No
ashlega 34,477 on at

Like (0)

Report

Hi Vijay,

if you want all the records, you have to start thinking "view/query" rather than "grid". For the grid control, you'll get only those rows which are displayed. If, however, you re-write your javascript to go back to the server (webapi etc) and query all the same data from the server, you should be able to get all those records:

msdn.microsoft.com/.../mt742431.aspx

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

SA-08121319-0 4

#1

Calum MacFarlane 4

#3

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans