Activity Forums Salesforce® Discussions How can we create a relationship with conga composer in Salesforce? Reply To: How can we create a relationship with conga composer in Salesforce?

  • Ankit

    Member
    March 22, 2018 at 11:00 am

    Hi Neha,

    Here is the example of conga query

    SELECT Opportunity.Name, Opportunity.Type, Opportunity.Amount, Opportunity.CloseDate, Opportunity.StageName, (Select Contact.name from OpportunityContactRoles where IsPrimary = true) FROM Opportunity Where Opportunity.Account.Id = '{pv0}' order by Opportunity.CloseDate asc

    PV (or pv) stands for the parameter value, which is a value that can be passed into a filter on a Salesforce report or Conga query. It used in advance filter of conga query to take Value dynamically.

    Hope it may help 🙂