Dynamics Community Forum Thread Details

Create view based on linked entity used twice

Hello,

I want to create view which retrieves all activities which are assigned to two Salespeople, which have their two separate fields (lookup) on Account entity:

6457.pastedimage1592582929513v1.png

I'm able only to retrieve activites assigned to one of the representatives:

8715.pastedimage1592583343479v2.png

Here I'm going from 1:N relationship between Activity and User, and then, 1:N relationship between User and Account. This view correctly shows all activities assigned to all people that are Representative 1.

But pulling in the second field, it seems that it takes the inner result of all the clauses (so Activities for Users that are BOTH Representative 1 and 2, which is not a common case:

0172.pastedimage1592585085258v3.png

Here's the XML of the second query:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" >
<entity name="activitypointer" >
<attribute name="subject" />
<attribute name="activitytypecode" />
<order attribute="subject" descending="false" />
<link-entity name="systemuser" from="systemuserid" to="owninguser" alias="aa" >
<link-entity name="account" from="pr_representative1" to="systemuserid" alias="ab" />
<link-entity name="account" from="pr_representative2" to="systemuserid" alias="ac" />
</link-entity>
<attribute name="ownerid" />
<attribute name="createdon" />
<attribute name="activityid" />
</entity>
</fetch>

I'm not sure what I'm missing here... Is even this scenario achievable using FetchXML? Or do I need to lean towards the plugin or script? Or maybe something different?

My goal is to create a chart counting all of the activities for the both types of representative- maybe there's someting that can be done directly in chart structure?

Quick Links

Subscribe to this forum!