Is it possible to write a SOQL query to retrieve the Contacts associated to a Campaign as Campaign Members and then get a number of records related to those Contacts?
This will return a list of the Campaignmember Contacts:
Select id, firstname, lastname from Contact where id in (Select contactid from Campaignmember where campaignid = '701000000000000')
But I also need the Notes, Tasks and Opportunities records associated to those Contacts. I'm doing this to populate a Conga template so I can't use APEX or a multi-step process.
The post identified as a duplicate of mine Conga - Multiple Queries is solved by passing a single parent id to multiple separate queries. Generally this is done to show a single Conga document with information about the parent and related lists. (ex. Account info with a list of related Contacts, Opportunities, Calls Logged). I'm trying to take my first query which returns multiple Contacts from a Campaign Member list and pass those Id's to different queries to get records related to the Contacts. Instead of a document with a single Contact and related Opportunities, Tasks, etc., I would have Contact1 and its related records, Contact2 and its related records, Contact2 and its related records, etc.