• Satya M
  • NEWBIE
  • 0 Points
  • Member since 2012
  • SR. Developer

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

I want to retrieve some fields from the Quote object and the list of  child QuoteLineItems. 
I have a dyanmic SOQL query (field list for QuoteLineItems is dynamic).  The query runs fine but in viewing the debug output  the returned values do not seem to include the QuoteLineitems. 

Here is an example of my dynamic SOQL query.
I want to process thru the list using the OpportunityId and the QuoteLineItems for each record returned as inputs to another method.

select opportunityId, ( SELECT QuoeID,  PricebookEntryId,  discount, unitprice from QuoteLineItems ) from Quote where Id IN ('0Q0c000000020MUCAY')

Perhaps I'm trying to do too much in one query ;-)

  • June 13, 2014
  • Like
  • 0