Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

OpportunityActivity

Data source: CRM

<entity name="task">
<attribute name="subject"/>
<attribute name="activitytypecode"/>
<attribute name="description"/>
<order attribute="scheduledend" descending="false"/>
<filter type="and">
<condition attribute="activitytypecode" operator="eq" value="4212"/>
</filter>
<link-entity name="opportunity" alias="ab" link-type="inner" from="opportunityid" to="regardingobjectid">
<attribute name="msp_opportunitynumber"/>
<filter type="and">
<condition attribute="msp_solutionarea" operator="eq" value="394380001"/>
<condition attribute="estimatedclosedate" operator="on-or-after" value="2022-07-01"/>
</filter>
</link-entity>
<attribute name="activityid"/>
<attribute name="statecode"/>
<attribute name="prioritycode"/>
<attribute name="modifiedon"/>
<attribute name="owninguser"/>
<attribute name="owningbusinessunit"/>
<attribute name="ownerid"/>
<attribute name="modifiedby"/>
<attribute name="scheduledend"/>
<attribute name="createdon"/>
<attribute name="actualstart"/>
<attribute name="actualend"/>
<attribute name="createdby"/>
<attribute name="actualdurationminutes"/>
<order attribute="scheduledstart" descending="false"/>
<attribute name="msp_taskcategory"/>
<link-entity alias="activitypointerowningusersystemusersystemuserid" name="systemuser" from="systemuserid" to="owninguser" link-type="outer" visible="false">
<attribute name="internalemailaddress"/>
<attribute name="domainname"/>
<attribute name="azureactivedirectoryobjectid"/>
</link-entity>
<link-entity name="systemuser" from="systemuserid" to="createdby" link-type="outer" alias="a_3e0f56d6de4b4dc1abb8bab389a9d4f8" visible="false">
<attribute name="azureactivedirectoryobjectid"/>
<attribute name="domainname"/>
</link-entity>
<link-entity name="systemuser" from="systemuserid" to="modifiedby" link-type="outer" alias="a_f9300698fcd04ce6ade5b8b886da6a2a" visible="false">
<attribute name="azureactivedirectoryobjectid"/>
<attribute name="domainname"/>
</link-entity>
</entity>
</fetch>