Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
how to get subgrid record in crm 2013 by using javascript RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I want to count subgrid record in crm 2013 by using javascript. Please tell me how is it possible

    Monday, March 31, 2014 6:07 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Aamir,

    It may be loading issue try below code

    function FindControl() {
        if (document.getElementById('subgridName')!= null) {
            var count=document.getElementById('subgridName').control.get_totalRecordCount();
            alert(count);
            }
            else {
                setTimeout("FindControl()", 1000);
            }
        }

    Our Website | Our Blog | Follow US | My Facebook Page | Microsoft Dynamics CRM 2011 Application Design
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.


    Tuesday, April 1, 2014 8:14 AM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    Did you check this

    Our Website | Our Blog | Follow US | My Facebook Page | Microsoft Dynamics CRM 2011 Application Design
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    Monday, March 31, 2014 6:49 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes I checked this but it is not working in crm 2013
    Monday, March 31, 2014 6:53 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Actually there is not supported way to interact with subgrids, so to make it work with ms crm 2013 you might need to do some changes.

    Our Website | Our Blog | Follow US | My Facebook Page | Microsoft Dynamics CRM 2011 Application Design
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    Monday, March 31, 2014 7:03 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi try this Line  .. I have checked it on Account and Contact form ...

    Xrm.Page.ui.controls.get('Contacts').$Y_0.get_totalRecordCount()

    Zafar Khan

    Monday, March 31, 2014 12:13 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Zafar,

    Xrm.Page.ui.controls.get('Contacts').$Y_0.get_totalRecordCount()

    what is $Y_0?

    Monday, March 31, 2014 1:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Aamir,

    $Y_0 is probably the dynamically generated object name that contains the get_totalRecordCount() method. While this might work, a single rollup can mess it all up if the object name changes. This is a highly unsupported and risky customization in my opinion.

    Admin QuikView Solution for CRM 2013

    Monday, March 31, 2014 4:47 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    HI

    AS Dynamotion said , these are unsupported .

    U can try

    document.getElementById('Contacts').control.get_totalRecordCount()

    Zafar Khan

    Tuesday, April 1, 2014 7:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Zafar,

    I tried this but it is not working in crm 2013

    var count=document.getElementById('subgridName').control.get_totalRecordCount();

    alert(count);

    Tuesday, April 1, 2014 7:09 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Aamir,

    It may be loading issue try below code

    function FindControl() {
        if (document.getElementById('subgridName')!= null) {
            var count=document.getElementById('subgridName').control.get_totalRecordCount();
            alert(count);
            }
            else {
                setTimeout("FindControl()", 1000);
            }
        }

    Our Website | Our Blog | Follow US | My Facebook Page | Microsoft Dynamics CRM 2011 Application Design
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.


    Tuesday, April 1, 2014 8:14 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    document.getElementById() this is DOM property. And DOM property does not support in dynamic CRM 2013/15

    Rajnikant

    Thursday, February 26, 2015 11:29 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Zafar,

    $Y_0 this is undefined property or null reference. How did you use?

    Rajnikant

    Thursday, February 26, 2015 11:33 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I would say the support for this is 98%.. the only thing that could mess it up is the function name "get_recordCount" changes...

    I have made this so that it can find the object the get_recordCount function is defined in and return the count. so it could be in '$Y_0', '$d_0', '$s_0'.. does not matter.

    var ctrl = Xrm.Page.getControl("SubGridName");

    for(prop in ctrl)
    {
    if(typeof ctrl[prop].get_recordCount === 'function')
    {
    alert(ctrl[prop].get_recordCount());
    break;
    }
    }

    Please let me know if this does not work for you.. so I can work on for other scenarios.

    Ramu

    Wednesday, April 22, 2015 7:19 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Ramu , I tried this but it is not working i am not able to get Associated Records count 
    • Proposed as answer by aneel503 Wednesday, September 23, 2015 10:48 AM
    • Unproposed as answer by aneel503 Wednesday, September 23, 2015 10:48 AM
    Monday, September 21, 2015 1:08 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Aamir Hijazi

    you can use below code to get sub grid control and number of records in sub grid 

    function allRecords() {

    var allGridRowData = [];

        var rows = Xrm.Page.getControl("Contacts").getGrid().getRows();//Contacts is a Sub Grid name

        rows.forEach(function (row, i) {

            allGridRowData.push(row.getData());

        });

    }

    Here you can get row count and also you can see data 

    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    Anil kumar Rai


    • Proposed as answer by aneel503 Wednesday, September 23, 2015 10:55 AM
    • Edited by aneel503 Wednesday, September 23, 2015 11:03 AM
    Wednesday, September 23, 2015 10:55 AM