Dynamics Community Forum Thread Details

Hi all,
I have a program Entity and another entity is "Allocation".
This Allocation Entity Dont have the Direct Relationship with Program.
"Allocation" has lookup of entity "Lender", has lookup of entity "LegalName", has lookup of entity "Program".
So, I have added the subgrid of "Allocation" entity on program entity and onLoad I am passing the filter in Allocation entity subgrid, but I am receiving and error pop-up
error is: 'allocation' entity doesn't contain attribute with Name = 'program' and NameMapping = 'Logical'

I am using Grid control to set the FetxhXml Filter

                gridContext.setFilterXml(FetchXml);               
                formContext.getControl("gridname").refresh();

FetchXml

 "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>" +
                    "<entity name='allocation'>" +      
                    "<link-entity name='account' from='accountid' to='lender' link-type='inner' alias='aa'>"+
                    "<link-entity name='legalname' from='alenderid' to='accountid' link-type='inner' alias='ab'>"+
                    "<filter type='and'>"+
                     "<condition link-entityname='ab' attribute='program' operator='eq'  value='"+programId+"' />"+
                    "</filter>"+            
                  "</link-entity>" +
                  "</link-entity>" +
                    "</entity>" +
                    "</fetch>";

The same fetch is giving the correct result in XRMTooBox(Fetch XML Tester).
As I have debugged the code and found that, the filter I am trying to add under link entity that is applying directly in the "Allocation" entity
fetch from the developer tool(Network):

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" savedqueryid="gh5e0c29-b72c-f011-8c4e-002248abcdef" returntotalrecordcount="true" page="1" count="50" no-lock="false">
  <entity name="allocation">
    <link-entity name="account" from="accountid" to="acl_lender" alias="aa">
      <link-entity name="legalname" from="lenderid" to="accountid" alias="ab">
        <filter type="and">
          <condition attribute="program" operator="not-null" />
        </filter>
      </link-entity>
    </link-entity>
    <attribute name="allocationid" />
    <filter type="and">
      <condition attribute="program" operator="eq" value="{8IJK1790-B7D7-EB11-ABCD-000D3A15EFGH}" />
    </filter>
  </entity>
</fetch>

Categories:

Microsoft Dynamics CRM

Dynamics 365 Sales