Selecting multiple values using concat function

[seahyanzheng]

Hi,

May i ask how do i select multiple values on field event trigger?

For example, on "_metricNo" selections, i like "_metrics" to be selected.

Im able to get "_metrics" values:

='(' & concat(''& _metrics & '','|') & ')' which returns these values

and i put in get field selection for "_metrics" but it doesnt get selected. The values above are delimited by '|'.

May i ask how do i proceed?

Thanks!

[ashwinisondkar]

Could you please try below expression

='('&Concat(_Metrics,'|')&')'

[seahyanzheng]

Manage to get the answer:

='(' & Concat(DISTINCT chr(34) & _metrics & chr(34), '|') & ')' instead of

='(' & concat(''& _metrics & '','|') & ')'

Thanks.