web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to fetch quotes fo...
Microsoft Dynamics CRM (Archived)

How to fetch quotes for opportunity.

(0) ShareShare
ReportReport
Posted on by Mohammad Sharique 290

Hi All,

I am working on the C# console application to fetching the opportunity quote records for respective opportunity, Kindly let me know how i can fetch the quotes for respective opportunity records.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    QueryByAttribute query = new QueryByAttribute("quote");

    query.ColumnSet = new ColumnSet(true);

    query.AddAttributeValue("opportunityid", respectiveOpportunity.Id);

    EntityCollection retrievedQuotes = service.RetrieveMultiple(query);

  • Sean Michel Profile Picture
    Sean Michel 340 on at

    Hi Mohammad,

    Kyle has provided one correct method to retrieve this data. In addition to using ColumnSet, you can utilize LINQ queries, and Fetch queries.

    (see here for LINQ)

    msdn.microsoft.com/.../gg328328.aspx

    The advantage to LINQ is that it will return all results without requiring Paging. Really this can be positive or negative based on whatever your situation calls for.

    (see here for Fetch)

    msdn.microsoft.com/.../gg328117.aspx

    Fetch, like ColumnSet, will require that you page through your results, if you are trying to return a large number of records.

    Hope it helps!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans