QueryID

Category: Data Gathering Parameter

Compatible with: Conga Quote Generation

Parameter Name: QueryID

Parameter Value: [Salesforce ID of a Query record]

Parameter Requirements: None

Parameter Description: QueryID retrieves the SOQL query stored in the specified Salesforce record, executes the SOQL query and makes the SOQL query results available through a dataset as seen on the Template Builder window.

It may optionally include filter criteria. The FROM clause in a query must pull from SBQQ, BLNG and APXTCFQ objects only.

Example query: SELECT Id, Name FROM SBQQ__Quote__c

You may include up to 50 QueryID values in a Conga Quote Generation URL, thus making 50 queries accessible in a single merge operation. Conga Quote Generation will retrieve a query that contains a maximum of 2,500 rows.

Example of two Queries: &QueryId=[contacts]a00143532453dg32,[cases]a00143532453dg32

Note on Query Aliases: An optional query alias may precede the query ID: Enclose the alias in square brackets Minimum 2 characters, maximum 20 Alphanumeric characters only Reserved sheet names may not be used (Master, Org, etc.) The alias must be unique within the button URL Query With Alias: &QueryId=[Contacts]a00143532453dg

Example of two Aliases: &QueryId=[Accounts]a00143532453dg32,[Cases]a0043532453dgF2

Example:

&QueryId=[queryAlias]a0341000000ABcd