Placeholders for SQL queries

When you create filters, you build SQL queries. For some cases, you will need to pass data to filters. You will use placeholders to accept this data as input to the SQL statement for your query.

You can use these placeholders.

Placeholder

Value

%C

This placeholder is the account ID. Use this placeholder for filter groups with account context.

%L

This placeholder is the language ID of the current user context.

%R

M3 CLM codes passed to the child filter. This placeholder is used for filters with other entities.

%A

This placeholder is the account number.