Apex Code Development You need to sign in to do that
Don't have an account?
John Stanczak How To retrieve field values from all Quote Line Items of a given Quote using SOQL
I'm attempting to write a SOQL Query that will pull a custom field value Category_ID__c from all of a quotes line items and then render them on a template. However The Query only seems to return the value from line item.
Here is the Query:
SELECT Category_ID__c
FROM quotelineitem
WHERE quote.id='{{!quote.id}}'
and here is the list of lineitems I am querying from:
I'd like for the Query to return all of the Category IDs for every line item.
so far this is all I get:
Can someone tell me what I am doing wrong here? Thanks.
Here is the Query:
SELECT Category_ID__c
FROM quotelineitem
WHERE quote.id='{{!quote.id}}'
and here is the list of lineitems I am querying from:
I'd like for the Query to return all of the Category IDs for every line item.
so far this is all I get:
Can someone tell me what I am doing wrong here? Thanks.
Try the suggestions as mentioned in the below blogs,
https://salesforce.stackexchange.com/questions/157148/soql-query-to-retrieve-quote-line-item-records-from-quote-record
https://success.salesforce.com/answers?id=9063A000000iZhfQAE
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks.