You need to sign in to do that
Don't have an account?
JoeyLen
SOQL query for Conga
Afternoon,
I need to access fields from related records (Master Detail) to the Op from the Quote. Need to create a Conga Query to gather these fields that is executed from the SBQQ Quote record.
I think I am close. I know the relationship from the Op to the Quote works, just not sure how to traverse down to the "Rhythm Sites".
SELECT Account_Name__r.Name, Opportunity__r.Name, Rhythm_Site__r.Name, Rhythm_Site_Ship_To_Address__r.Ship_To_City__c, Rhythm_Site_Ship_To_Address__r.Ship_To_State__c, Rhythm_Site_Ship_To_Address__r.Ship_To_Street__c, Rhythm_Site_Ship_To_Address__r.Ship_To_Zip__c, POC_email__c, POC_Phone__c, POC_Title__c, Site_POC__c, Site_POC__r.Email, Site_POC__r.Name FROM Rhythm_Sites__c WHERE Id in (Select Opportunity__c FROM SBQQ__Opportunity2__c FROM SBQQ__Quote__c WHERE id = '{pv0}')
I need to access fields from related records (Master Detail) to the Op from the Quote. Need to create a Conga Query to gather these fields that is executed from the SBQQ Quote record.
I think I am close. I know the relationship from the Op to the Quote works, just not sure how to traverse down to the "Rhythm Sites".
SELECT Account_Name__r.Name, Opportunity__r.Name, Rhythm_Site__r.Name, Rhythm_Site_Ship_To_Address__r.Ship_To_City__c, Rhythm_Site_Ship_To_Address__r.Ship_To_State__c, Rhythm_Site_Ship_To_Address__r.Ship_To_Street__c, Rhythm_Site_Ship_To_Address__r.Ship_To_Zip__c, POC_email__c, POC_Phone__c, POC_Title__c, Site_POC__c, Site_POC__r.Email, Site_POC__r.Name FROM Rhythm_Sites__c WHERE Id in (Select Opportunity__c FROM SBQQ__Opportunity2__c FROM SBQQ__Quote__c WHERE id = '{pv0}')
MyLowesLife (https://www.myloweslife.win/)