Expressions in external data source

In the function properties, in the Expression in the data source field, click the selection button.

In the text box, type the expression in the source query language, with parameters included.

Use the following parameter notation: &n, where n is the number of the actual parameter, starting from 1.

Use the following notation for a variable number of parameters: &n[]. When actual parameters are passed to the expression, a sting of comma-separated parameters replaces &n[]. Only the last parameter can have a variable number of values.

Enclose optional parameters in braces {}. During the call, if optional parameters are not specified, their values are set to NULL.

1C:Enterprise Developer's Community