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, 2017 at 0:52

2 Answers 2


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

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 .