locked
List of all Opportunities with attachment column, attachments are attached from Accounts entity ? RRS feed

  • Question

  • Hi All,

    I am working on report for online crm2013, I have requirement to get the all opportunity list with attachment column, attachments  which attached from accounts entity. Please let me know how we can get it using fetch xml query.

    Report will look like as below snap.

    Note : As shown null means account have attachment or may not have 

    Regards,

    Mohammad Sharique



    Monday, December 29, 2014 10:37 AM

All replies

  • I'm not sure what do you mean by "attachments attached from accounts entity". How are you attaching attachment with opportunity through account entity?

    I think retrieve of opportunity attachment should be simple. Opportunity have Customer lookup. You can query All Opportunity with Customer equals Account. And retrieve all attachments associated with that opportunity.

    Monday, December 29, 2014 12:48 PM