Filter Grid using JavaScript on MS CRM 2016 and above

Since there is no supported way to filter a grid over MS CRM till now. An unsupported way expire from version to version.

For CRM 2016 and above, use below code to filter a sub grid if parent entity and child entity doesn’t have any relationship and you wish to filter a grid base on lookup value.

function FilterSubgrid()

{

    var filterId = Xrm.Page.data.entity.getId();

    var yoursubgridnameObject = window.parent.document.getElementById(“<GridName>”);

    if (yoursubgridnameObject == null || yoursubgridnameObject.control == null) {

        setTimeout(‘FilterSubgrid()’, 1000);

        return;

    }

    if (filterId == null) return;

    var fetchXml = “<fetch version=’1.0′ output-format=’xml-platform’ mapping=’logical’       distinct=’true’>”;

    …

    fetchXml =fetchXml+ “</fetch>”;

    yoursubgridnameObject.control.SetParameter(“fetchXml”, fetchXml);

    yoursubgridnameObject.control.refresh();

}

Thanks.