Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

Create view with outer join (fetchxml) not working?

Posted on by 880

Hi,

I tried creating a view from customer asset to show the customer assets and what customer assets are linked to work order incidents. For testing i set a parameter to only show the customer asser with a specific ID (custom field) -> cus1_parentassetid. There is only one customer asset with this ID. However multible work order incidents assciated to the customer asset. In fetchXML builder for xrmtoolbox i get 2 results (Because the 1 customer asset is related on 2 work order incidents). So everything is fine in fetchxml. However when i upload the fetchxml to my view in CRM it only shows 1 record? And in the botton of the view it will show "1 - 2 of 2 (0 selected)". Why can i only see 1 record in CRM and not 2?

<fetch version="1.0" distinct="false" >
  <entity name="msdyn_customerasset" >
    <attribute name="createdon" />
    <attribute name="msdyn_customerassetcategory" />
    <attribute name="cus1_parentassetid" />
    <attribute name="cus1_customerid" />
    <attribute name="cus1_address1zippostalcode" />
    <attribute name="cus1_address1street2location" />
    <attribute name="cus1_address1street1location" />
    <attribute name="cus1_address1city" />
    <attribute name="cus1_locationcuscription" />
    <attribute name="cus1_address1name" />
    <attribute name="cus1_subcategory" />
    <attribute name="cus1_address1countryregion" />
    <attribute name="cus1_serialnumberparent" />
    <attribute name="cus1_cusmiproductmodel" />
    <attribute name="cus1_cusmimanufacturer" />
    <attribute name="msdyn_customerassetid" />
    <order attribute="cus1_serialnumberparent" cuscending="false" />
    <filter type="and" >
      <condition attribute="statecode" operator="eq" value="0" />
      <condition attribute="msdyn_parentasset" operator="null" />
      <condition attribute="cus1_parentassetid" operator="eq" value="114317" />
    </filter>
    <link-entity name="msdyn_workorderincident" from="msdyn_customerasset" to="msdyn_customerassetid" link-type="outer" />
  </entity>
</fetch>

  • rskadk1 Profile Picture
    rskadk1 880 on at
    RE: Create view with outer join (fetchxml) not working?

    No one who knows this?

  • rskadk1 Profile Picture
    rskadk1 880 on at
    RE: Create view with outer join (fetchxml) not working?

    I can see my view us working from advanced views (2 records displayed) but not from the unified interface (Only 1 record displayed)?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans