I want to extract the list of opportunities where a specific user is added in the access team (created by using access team template). What are the different ways and how to proceed?
e.g.
1)Console application
2) SSRS Report
*This post is locked for comments
You might try a report (using report wizard)..
It was a little different here:
community.dynamics.com/.../234601
But, if you follow the same approach, add a filter for the user and if you group by user name.. you might, then, add opportunity(regarding object id) to the columns.
Hi,
This is possible using a simple Advanced Find query:
You can also use the following fetchxml in a report or a console application:
Share
Report
All responses (
Answers (
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="opportunity">
<attribute name="name" />
<attribute name="customerid" />
<attribute name="estimatedvalue" />
<attribute name="statuscode" />
<attribute name="opportunityid" />
<order attribute="name" descending="false" />
<link-entity name="team" from="regardingobjectid" to="opportunityid" alias="aj">
<filter type="and">
<condition attribute="teamtype" operator="eq" value="1" />
</filter>
<link-entity name="teammembership" from="teamid" to="teamid" visible="false" intersect="true">
<link-entity name="systemuser" from="systemuserid" to="systemuserid" alias="ak">
<filter type="and">
<condition attribute="systemuserid" operator="eq-userid" />
</filter>
</link-entity>
</link-entity>
</link-entity>
</entity>
</fetch>
Hope this helps!
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
