Dynamics Community Forum Thread Details

Good Morning,
I've been having a lot of issues with this Javascript solution.

The primary goal is to have a subgrid on a separate tab that will give us a view into another entity. The Ideas is to Dynamically set the fetch to this subgrid based on values of Custom Entity lookups on the case form. However, when its ran it returns blank even though I've verified that Items exist. Below is my code.

function CustEntity1_refresh(executionContext){    var formContext = executionContext.getFormContext();    var Custentity2 = formContext.getAttribute('Cust_entity2').getValue();   // get the subgrid controlvar subGridControl = formContext.getControl(/Case_CustEntity1/);// get the view associated with the subgrid control//var viewId = subgridControl.getViewId();var custEntity2Id=Custentity2[0].id;alert(custEntity2Id);custEntity2Id=custEntity2Id.replace(/{/,//);alert(custEntity2Id);custEntity2Id=custEntity2Id.replace(/}/,//);alert(custEntity2Id);// set the fetchxml query for the view, filtering based on your criteria var fetchXml = /<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>/+/<entity name='cust_entity1'>/+/<attribute name='cust_name' />/+/<attribute name='cust_entity2' />/+/<attribute name='createdon' />/+/<attribute name='cust_entity3' />/+/<attribute name='cust_entity1Id' />/+/<order attribute='cust_name' descending='false' />/+/<filter type='and'>/+ /<condition attribute='statecode' operator='eq' value='0' />/+/<condition attribute='cust_entity2' operator='eq'  uitype='cust_entity2' value='/+ custEntity2Id.toLowerCase() + /'/>/+ /</filter>/+/</entity>/+/</fetch>/;alert(fetchXml);// set the view XML of the subgrid with updated filter criteriasubGridControl.setFilterXml(fetchXml); formContext.getControl(/Case_Custentity1/).refresh();alert(formContext.getControl(/Case_Custentity1/).getFetchXml());}function callBackFunction(result) {if (result == 'success') {} else {} }

For the above code(various references changed for anonymity sake), I've been able to receive all alerts which tells me there isn't a compilation or syntax error.
Using the alert(fetchXml) I was able to grab the fetch generated and after converting single quotes to double quotes was able to get return records using the XRM toolbox Fetch XML tester. This tells me that the fetch isn't bad.
I am seeing the view switch from its default view to blank so this tells me I'm using the right control name and am targeting the right control.

However, one thing I do find interesting is that the last alert returns Null.

This has got me stumped. If anyone has any suggestions it would be greatly appreciated.