What's the soql que...
 
Notifications
Clear all

[Solved] What's the soql query to fetch cpq quotes from opportunity?

2 Posts
1 Users
0 Likes
371 Views
Posts: 205
 CWL
Admin
Issue starter
(@cwl)
Member
Joined: 11 years ago

How to get all the related cpq quotes with the opportunity name?

Issue Tags
1 Reply
Posts: 205
 CWL
Admin
Issue starter
(@cwl)
Member
Joined: 11 years ago

SELECT Id, Name FROM SBQQ__Quote__c WHERE SBQQ__Opportunity2__r.Name = 'OppName'

With bind variable it will be: SELECT Id, Name FROM SBQQ__Quote__c WHERE SBQQ__Opportunity2__r.Name=:varName

Reference: Salesforce CPQ interaction with Opportunity Fields

"A Quote will be related to the Opportunity if the Quote's Opportunity Lookup field (SBQQ__Opportunity2__c) is populated with the Opportunity."

Also: CPQ Object Relationships (salesforce.com)

Reply
Share: