TPV

Category: Advanced Data Formatting Parameter

Compatible with: Composer 7 and Composer 8

Parameter Name: TPV

Parameter Value: [0 or 1]

Parameter Requirements: None

Parameter Description: TPV (Translate Picklist Values) retrieves translated picklist field values. For organizations where picklist values have been translated via the Translation Workbench, this setting enables Conga Composer to retrieve the translated values.

This parameter does not work with SOQL queries; use toLabel() on the picklist field instead.

Example of SOQL query:

SELECT Payment_Frequency__c, Quantity, UnitPrice 
FROM OpportunityLineItem 
WHERE OpportunityId = '{pv0}' ORDER BY UnitPrice DESC

CODE

Example of the query using toLabel():

SELECT toLable(Payment_Frequency__c), Quantity, UnitPrice 
FROM OpportunityLineItem 
WHERE OpportunityId = '{pv0}' ORDER BY UnitPrice DESC

CODE

Value	Definition
0	Picklist values are not translated. (default)
1	Picklist values are translated to the language specified in the Personal Information settings of the user.

Example:

&TPV=1