Notifications
Clear all
Nov 23, 2022 7:00 am
SOQL to fetch Account Name, Opportunity Name along with SBQQ__Quote__c fields.
SELECT Id, Name,
SBQQ__Account__c, SBQQ__Status__c, SBQQ__Primary__c, CurrencyIsoCode,
CPTSUP__c, CPTSUPR__c
FROM SBQQ__Quote__c
WHERE SBQQ__Primary__c = true AND SBQQ__Opportunity2__r.Id = :keySearch
I also need to fetch its account name and opportunity name along with it - how do I do that?
1 Reply
Nov 23, 2022 7:01 am
SELECT Id, Name,
SBQQ__Account__c,SBQQ__Account__r.Name,SBQQ__Opportunity2__r.Name, SBQQ__Status__c, SBQQ__Primary__c, CurrencyIsoCode,
CPTSUP__c, CPTSUPR__c
FROM SBQQ__Quote__c
WHERE SBQQ__Primary__c = true AND SBQQ__Opportunity2__r.Id = :keySearch
