Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How get the List of Opportunities with attachment column attached from Accounts entity ? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    I have requirement to get the all opportunity list with attachment, which attached from accounts entity. So please let me know how we can get it using fetch xml query.

    Account        Opportunity  Attachement

    ABCD1 Opp1                  Attachement1.txt

    ABCD2 Opp2                   Attachement2.txt

    ABCD3 Opp3                  Attachement3.txt

    Note : Here attachments are which attached from account entity.

    Thanks in Advance



    Tuesday, December 23, 2014 11:51 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Use this fetchxml:

    <?xml version="1.0"?>

-<fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0">


-<entity name="opportunity">

<attribute name="name"/>

<attribute name="customerid"/>

<attribute name="estimatedvalue"/>

<attribute name="statuscode"/>

<attribute name="opportunityid"/>

<order descending="false" attribute="name"/>


-<link-entity name="account" alias="aa" to="parentaccountid" from="accountid">


-<link-entity name="annotation" alias="ab" to="accountid" from="objectid">


-<filter type="and">

<condition attribute="isdocument" value="1" operator="eq"/>

</filter>

</link-entity>

</link-entity>

</entity>

</fetch>

    Regards, Saad

    Wednesday, December 24, 2014 6:14 AM