• Gagnon Michel
  • NEWBIE
  • 0 Points
  • Member since 2021

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
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}')