Remove From My Forums

Filtering sub grid record based on lookUp value in Microsoft Dynamics CRM 2011.

Question
0

Sign in to vote

Giving Error :-
Line: 1
Error: 'UpdateSubGrid' is undefined

This is the function i am using to filter subgrid. It was working proper before upgrade rollup12.

function funName_onload()
{
var grid = document.getElementById('LeadActivity');
if (grid ==null)
{
setTimeout('UpdateSubGrid()', 2000);
}
else {
var lookupfield = new Array;
lookupfield = Xrm.Page.getAttribute("originatingleadid").getValue();
if (lookupfield != null) {
var lookupid = lookupfield[0].id;
}
else {
return;
}
var fetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>";
fetchXml += "<entity name='activitypointer'>";
fetchXml += "<attribute name='regardingobjectid' />";
fetchXml += "<filter type='and'>";
fetchXml += "<condition attribute='regardingobjectid' operator='eq' value='" + lookupid + "' />";
fetchXml += "</filter>";
fetchXml += "</entity>";
fetchXml += "</fetch>";

grid.control.SetParameter("fetchXml", fetchXml);
grid.control.Refresh();
}
}

Saturday, October 5, 2013 8:52 AM

Answers

function funName_onload()
 {    
     var grid = document.getElementById('LeadActivity');
     if (grid ==null)
     {
       setTimeout('funName_onload()', 2000);
     }
     else {
           var lookupfield = new Array;
           lookupfield = Xrm.Page.getAttribute("originatingleadid").getValue();
           if (lookupfield != null) {
              var lookupid = lookupfield[0].id;
              }        
           else {
                return;
                }
          var fetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>";
          fetchXml += "<entity name='activitypointer'>";
          fetchXml += "<attribute name='regardingobjectid' />";        
          fetchXml += "<filter type='and'>";
          fetchXml += "<condition attribute='regardingobjectid' operator='eq' value='" + lookupid + "' />";
          fetchXml += "</filter>";       
          fetchXml += "</entity>";
          fetchXml += "</fetch>";

          grid.control.SetParameter("fetchXml", fetchXml);
          grid.control.Refresh();
         }
 }

Hi Suresh,

I think your function name is not quite correct, as per the error message 'UpdateSubGrid' is undefined, you may need to change your UpdateSubGrid to funName_onload in your code so that when your grid is not ready, it would wait then call itself again.

Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

Marked as answer by Suresh Sorde Saturday, October 5, 2013 10:43 AM
Unmarked as answer by Suresh Sorde Saturday, October 5, 2013 10:43 AM
Marked as answer by Suresh Sorde Saturday, October 5, 2013 10:43 AM

Saturday, October 5, 2013 10:07 AM

0

Sign in to vote
Check your subgrid Data Source settings, use All Record Types. In this example, I am using Open Activities as the default view but you can use which ever suites your needs.

Eric UNG [Senior Analyst Programmer :: Sydney, Australia]
- Marked as answer by Suresh Sorde Saturday, October 5, 2013 10:43 AM
Saturday, October 5, 2013 10:39 AM

All replies

function funName_onload()
 {    
     var grid = document.getElementById('LeadActivity');
     if (grid ==null)
     {
       setTimeout('funName_onload()', 2000);
     }
     else {
           var lookupfield = new Array;
           lookupfield = Xrm.Page.getAttribute("originatingleadid").getValue();
           if (lookupfield != null) {
              var lookupid = lookupfield[0].id;
              }        
           else {
                return;
                }
          var fetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>";
          fetchXml += "<entity name='activitypointer'>";
          fetchXml += "<attribute name='regardingobjectid' />";        
          fetchXml += "<filter type='and'>";
          fetchXml += "<condition attribute='regardingobjectid' operator='eq' value='" + lookupid + "' />";
          fetchXml += "</filter>";       
          fetchXml += "</entity>";
          fetchXml += "</fetch>";

          grid.control.SetParameter("fetchXml", fetchXml);
          grid.control.Refresh();
         }
 }