Microsoft Dynamics CRM (Archived)

getting list of records in a subgrid using javascript

(0) Share

Report

Posted on by svignesh

347

I want to get list of all records that are in a subgrid

Is there a way to get it using some api call or using javascript?

I don't want to have the subgrid and then hide it in the page where I am going to fetch these records, I have tried selected rows and get, but that is not what I need


var selectedRows = Xrm.Page.getControl("Contacts").getGrid().getSelectedRows();
var rows = Xrm.Page.getControl("Contacts").getGrid().getRows();

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Jason M. Cosman 5,234 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello Vicky;

What are you going to do with this listing of records in the sub grid? Is this subgrid showing a 1:M or M:M relationship? It would be just as easy to do a FetchXML or WebAPI call for these records instead of interrogating the subgrid for its results. Looking into the sub grid might not be the best as you need to ensure it's properly loaded its date.

In your logic if I understand correctly you want to be able to hide the subgrid but still get it's rows? If this is the case then get selected rows deffinetly isn't going to work as it will be hidden with no selected rows. In terms of the getRows call below it; are you sure your subgrid is called "Contacts"?

Let me know what you think!

Was this reply helpful? Yes No
svignesh 347 on at

Like (0)

Report
Copy link

Link copied!

Hello Jason,

I have a children subgrid and a Parent subgrid in the case entity

There will be some goals that will be added for a case, in the Goal I want to show the list of parents in the subgrid as an autocomplete field to specify the parent(parent list who are in that particular case) for whom the goal is for

Was this reply helpful? Yes No
Verified answer

Jason M. Cosman 5,234 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hello Vicky;

Ok cool; so you are looking at a 1:M relationship with multiple parents for this one account. I'd definitely recommend going to get the data from that relationship instead of pulling it from the subgrid. You should be able to do a fetchxml or webapi call for the data.

Was this reply helpful? Yes No
Suggested answer

Aiden Kaskela 19,696 on at

Like (1)

Report
Copy link

Link copied!

Hi Vicky,

I'm not sure what your end goal is. Are you trying to get the data from the grid, or run a query so you don't need to rely on the grid?

getRows will give you back all the rows in the grid, and you can call row.getData().getEntity() to get the record represented by the row.

If you want to query via javascript, you can using the specs here: msdn.microsoft.com/.../gg985387.aspx

Hope this helps! I'd appreciate if you'd mark this as Answering your question.

Thanks,

Aiden

Was this reply helpful? Yes No
svignesh 347 on at

Like (1)

Report
Copy link

Link copied!

Hello Jason,

Not able to delete the post, found out there was a typo in the name, kindly ignore

How can I select the data in the subgrid using webapi?

I tried

localhost/.../new_medicalCase(687615e4-3e05-e611-9419-000d3a1045a2)$expand=FamilyMembers($select%20=%20new_name)

and got this error

{

"error":{

"code":"","message":"Could not find a property named 'FamilyMembers'

Not able to delete the post, found out there was a typo in the name

Was this reply helpful? Yes No
Jason M. Cosman 5,234 Moderator on at

Like (1)

Report
Copy link

Link copied!

So your original code worked just a typing mistake? That's wonderful news great job!

Was this reply helpful? Yes No
svignesh 347 on at

Like (1)

Report
Copy link

Link copied!

Hello Jason,

Not the original post, I meant the last reply post with webapi link :)

Was this reply helpful? Yes No

Community site session details

getting list of records in a subgrid using javascript

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

getting list of records in a subgrid using javascript

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates