Scenario: 
I need to filter the subgrid to act as view.
Decided to create a custom subgrid view to filter based on all the records in the subgrid.
This is what i code for javascript and put it on onload form function.
Code:
function updateSubGrid() {
    var relatedProducts = document.getElementById("SubgridProjects");
    var lookupfield = new Array;
    lookupfield = Xrm.Page.getAttribute("vw_projectnoid").getValue();
    if (lookupfield != null) { var lookupid = lookupfield[0].id; }
    else { return; }
    if (relatedProducts == null || relatedProducts.readyState != "complete") { setTimeout('updateSubGrid()', 2000); return; }
    var fetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>";
    fetchXml += "<entity name='vw_project'>";
    fetchXml += "<attribute name='vw_projectid' />";
    fetchXml += "<attribute name='vw_projectno' />";
    fetchXml += "<attribute name='vw_titlestatus' />";
    fetchXml += "<attribute name='vw_landtenure' />";
    fetchXml += "<order attribute='vw_projectno' descending='false' />";
    fetchXml += "<filter type='and'>";
    fetchXml += "<condition attribute='vw_projectid' operator='eq' value='" + lookupid + "' />";
    fetchXml += "</filter>";
    fetchXml += "</entity>";
    fetchXml += "</fetch>";
    relatedProducts.control.setParameter("fetchXml", fetchXml);
    relatedProducts.control.refresh();
    document.getElementById("SubgridProjects_span").disabled = true; //Disable the subgrid
}   
As u can c there no layout xml. Most of the custom view use fetch xml.  U can download ur fetch xml from advanced find.
CRM 2011 Update/ Custom Subgrid View/ FetchXML Subgrid
Posted by Unknown at 9/11/2012 02:21:00 pm
Labels: CRM 2011, Javascript
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment