Specifies a comma-separated list of columns for which picklist translation should be skipped when retrieving data.

Data Type

string

Default Value

""

Remarks

When TranslatePickListFields is enabled, the component automatically translates picklist values based on the user’s Certinia language settings. However, there may be specific columns where translations are not desired, and raw picklist values should be returned instead.

The SkipPickListTranslation property allows you to specify columns that should retain their original picklist values without translation. You can specify columns either fully qualified with their table name (for example, Table1.Col1) or by column name alone if the context is clear.

This property is useful for developers or analysts who need to preserve raw picklist values for reporting, consistency in exports, or integration with other systems that depend on untranslated picklist values.

Performance Considerations

Specifying columns to skip translation can reduce unnecessary API translation overhead and improve performance in large queries. It also helps avoid mismatches between translated values and reference data in external systems. Ensure that the listed columns are accurate to prevent translation from being skipped unintentionally.