Dynamics Community Forum Thread Details

Using fetchXML and Link entity on a subgrid

Hi,

If your FetchXML works in XrmToolBox but not in the subgrid, make sure you’re setting it after the subgrid is loaded and using the correct control reference:
Here’s an example:

function onLoad(executionContext) {

    var formContext = executionContext.getFormContext();

    var subgrid = formContext.getControl("YOUR_SUBGRID_NAME");

    if (subgrid) {

        subgrid.addOnLoad(function () {

            var Name = formContext.getAttribute("c_name").getValue();

            var fetchXml = "<fetch mapping='logical' distinct='true'>" +

                "<entity name='c_dp'><attribute name='c_name' />" +

                "<link-entity name='c_dt' from='c_relatedtoprogram' to='c_dtpid' link-type='inner'>" +

                "<filter><condition attribute='c_name' operator='eq' value='" + Name + "' /></filter>" +

                "</link-entity></entity></fetch>";

            subgrid.setFilterXml(fetchXml);

            subgrid.refresh();

});

Notes:

Use an associated view subgrid — filters don’t apply to custom views.
Always call setFilterXml() after the subgrid has loaded.
Retrieve your field value inside addOnLoad.
Please checked table permission for both entities.
Use the browser console or F12 developer tools to debug and confirm your FetchXML works as expected inside console.