1

How would I retrieve all QuoteLineItem records from a Quote record?

  • While it doesn't seem unreasonable to close this question for lack of research, surely Too Broad is not the right reason. – Adrian Larson Jan 24 '17 at 0:52
4

In a parent query , you can use a child sub-query, formally known as a Left Outer Join:

SELECT Id, (SELECT Id FROM QuoteLineItems) FROM Quote WHERE ...

As a separate query:

SELECT Id FROM QuoteLineItem WHERE QuoteId = :parent.Id
3

Here is the syntax from Parent to Child:-

SELECT Id [Fields...,] ,
    ( SELECT Name, [..Fields,] FROM QuoteLineItems )
    FROM Quote
    WHERE Id=:Quote_ID

Child Relationship name of Quote Line Item is: QuoteLineItems

Not the answer you're looking for? Browse other questions tagged or ask your own question.