GEL Script String Append/Concatenation Does Not Work In GCP Environment

Products

• Clarity PPM SaaS

Issue/Introduction

The following functions used in GEL scripts that used to work in Oracle does not work for PostgreSQL.

1. NVL - null value lookup

2. String concatenation

Resolution

1. NVL is replaced by COALESCE

Example: 
nvl(external_id,' ') ext_id 
is replaced with
COALESCE(external_id,' ') ext_id

2.  'xx' || stringexample is replaced by CONCAT

Example:
'xx' || stringexample 
is replaced with
CONCAT('xx', stringexample)

Note: Any aliases will need to be removed.