Is it possible to join Queries on Conga? I'm testing out different reporting solutions and want to know if Conga will meet my needs.
Lets say I want to run a series of queries that with the final result being: Give me all Accounts that have bought a specific line of products in the past 5 years, and who do not have open cases.
My idea is to run something like:
Query 1 - Select AccountID from Case where Status = 'Open'
Query 2 - Select AccountID *and other fields* from Opportunity where Product_Line__c = 'Product Line' and AccountID not in Query 1.
Ideally I'd like to pull in another custom object related to Accounts. So something like:
Query 1 - Select AccountID from Case where Status = 'Open'
Query 2 - Select AccountID *and other fields* from Opportunity where Product_Line__c = 'Product Line' and AccountID not in 'Query 1'
Query 3 - Select AccountID *and other fields* from Custom_Object__c where AccountID in 'Query 2'
I can build all the individual queries in Conga. Where I'm running into trouble is the combining them part. I know you can do "pv0= AccountID". Will something like this work [Select ... Where AccountID Not in {Query 1 Alias}]?
