Skip to main content

#Conga Composer Query3 personnes en discutent

I'm having issues with Conga Composer in Lightning.   The main issue is the tabled data not being pulled into the agreement.  Everything else with the agreement doc is working as expected using Conga composer in lightning.   The table in my word doc template below is not pulling in when using lighting.  It works fine in classic.   We use conga queries instead of reports. 

 

Any ideas? 

 Here is the conga button I updated for lightning. 

 

/apex/APXTConga4__Conga_Composer?serverUrl={!API.Partner_Server_URL_370}&id={!

Opportunity.Id

&QVar1ID=a0Lo000000IhAoV?pv0={{!

Opportunity.Id

}} 

&TemplateGroup=Agreements-Workforce Management 

&TemplateId={!CASE(TEXT(Opportunity.Solution__c),"Safety","a0M1J00000CLxJS","Safety Staffing","a0M1J00000CLk3x","a0Mo000000BcqClEAJ")},{QVar1} 

&queryid=[PerHour]a0L1J00000KNycQ?pv0={!

Opportunity.Id

&queryid=[PerDay]a0L1J00000KNyqr?pv0={!

Opportunity.Id

&queryid=[OneTime]a0L1J00000KO2vA?pv0={!

Opportunity.Id

&queryid= a0Lo000000JaTu4 

&queryid=[Annual]a0Lo000000JZlek?pv0={!

Opportunity.Id

&queryid=[Safety]a0Lo000000JaTu4?pv0={!

Opportunity.Id

&queryid=[Workforce Management]a0L1J00000KO3Hs?pv0={!

Opportunity.Id

&DocuSignVisible=1 

&DS4=0 

&DS5={!IF($

Profile.Name

="System Administrator","1","0")} 

&DS6={!IF($

Profile.Name

="System Administrator","0","1")} 

&DS8={!IF($

Profile.Name

="System Administrator","1","0")} 

&DS9={!IF($

Profile.Name

="System Administrator","0","1")} 

&DS9={!IF($

Profile.Name

="'System Admin-Waiver MFA' ","0","1")} 

&SC0=1 

&SC1=Attachments 

&FP0=1 

&OFN={!Opportunity.Account}+-+Sheakley+Workforce+Mgmt+Svs+Agreement 

&Qvar0Id=a0Lo0000006y1Yv 

&DocuSignR1Id={Qvar0} 

&DocuSignR1Type=Signer 

&DocuSignR1Role=Signer+1 

&DocuSignR1RoutingOrder=1 

&DocuSignR2Id=005o0000001E3CBAA0 

&DocuSignR2Type=Signer 

&DocuSignR2Role=Signer+2 

&DocuSignR2RoutingOrder=2 

&DocuSignExpireIn=30

 

#Trailhead  #Salesforce Admin  #Conga Composer

 

 

#Conga Composer Template  #Conga Composer Query

2 réponses
  1. 3 sept., 09:11

    Hi @Scott Blase

     

    This is Conga Composer (AppExchange package) troubleshooting in scope, but different from core Apex/Flow. A few things jump out in your button before we even get to Lightning-specific causes. 

    Two issues I can already see in the URL itself: 

    1. &queryid= a0Lo000000JaTu4  no [Alias] prefix and no ?pv0= filter, unlike every other queryid param. That's either a leftover/duplicate or a copy-paste error — and it reuses the same ID as your [Safety] query below it, just without the alias or filter. An unaliased/unfiltered query like this can silently return the wrong (or zero) rows, or collide with the aliased dataset your template expects.
    2. &TemplateGroup=Agreements-Workforce Management has an unencoded space. Classic Salesforce sometimes tolerates this in URL buttons; Lightning's stricter parameter parsing may not, which can cause params after it to be misread depending on where it falls in the string.

    Since Conga confirms itself that a table not merging is a two-branch diagnosis (data-source problem vs. template problem), here's the order to check it in:

    1. Open the View Data Workbook: 
    2. Launch Composer from Lightning, open Tools & Settings > View Data, and check whether the table's dataset actually contains rows. If it's empty here, the problem is the data source (the Conga Query), not the template — skip straight to step 3.
    3.  If data IS present, check the template's TableStart/TableEnd alias: 
    4. Open the Word template and confirm the alias inside {{TableStart:Alias}} / {{TableEnd:Alias}} matches the bracketed alias on the queryid param exactly (e.g. [PerHour], [PerDay], [Safety]). A mismatch here is invisible in Classic if an older/report-based alias still happens to resolve, but breaks cleanly on Query-based Lightning setups.
    5.  Fix or remove the unaliased queryid 
    6. The param '&queryid= a0Lo000000JaTu4' (no alias, no pv0 filter, and reusing the same record ID as your [Safety] query) is almost certainly the culprit or at least a red flag. Give it a proper [Alias]?pv0={!Opportunity.Id} or delete it if it's leftover from an earlier version of the button. 
    7.  Confirm the button is OAuth-based, not session-ID based 
    8. Conga's own Lightning migration guidance requires URL buttons to be converted to OAuth buttons with Composer registered as a Connected App when moving from Classic to Lightning. If this button was carried over from Classic without that conversion, some data calls (especially secondary Conga Query calls for tables) can fail silently while the primary merge still works off the Opportunity Id alone. 
    9. Check Conga Query object sharing for the Lightning running user 
    10. Composer's query execution runs under the current user's sharing context. If the Conga Query (a0L) records or the underlying queried objects have sharing rules that differ for the user/profile combination used in Lightning vs Classic, the query can return zero rows for that user even though the query itself is valid.
    11.  Re-test one query at a time 
    12. Temporarily strip the button down to just the one queryid feeding the broken table, confirm it merges correctly, then add the others back one by one. This isolates whether it's a single bad query/alias or a systemic Lightning config issue.

    On step 1 or 2 since the rest of the doc works, auth/session is probably fine, so it's most likely either that malformed queryid param (step 3) or a template alias mismatch (step 2). Start with the View Data Workbook it'll tell you in 30 seconds whether you're chasing a query problem or a template problem. 

     

    I hope you find the above information helpful. If it does, please mark it as Best Answer to help others too.

0/9000

Some of my colleagues who are also System Administrators are receiving this error message however I am not.  The have the same profile as myself.  How do I fix this?

 

#Conga Composer Query

1 réponse
0/9000
Alison Butler a posé une question dans Conga

Getting error messages on a Solution when trying to access Template Builder:

 

1. "The id parameter is missing" (when accessed via Conga Solutions);

2. "Unable to retrieve Conga query from Salesforce. This could be an issue with visibility" (when accessed via button on object page).

 

I also note that the Solution requires a button update every time I open it, whether I have made any changes to it or not.  Anyone got any tips?

 

#Conga Composer @Conga #Conga Composer Query #Conga Solution Records

6 réponses
0/9000

Anyone having issues getting into the Conga Query Builder. We keep getting an "Unexpected Server Error" message. Just wanted to see if this is happening with anyone else. #Conga #Conga Composer Query

11 réponses
0/9000

Hello, Could anyone provide advice on how to get the list of Names that are on a Task in a Conga Composer Query? (My org has enabled allowing multiple Contacts on Activities). Thank you!

0/9000