Custom GEL Script Does Not Work for Update Statement in PostgreSQL Database

Products

• Clarity PPM SaaS

Issue/Introduction

Create a custom GEL script with an update statement such as:

update odf_ca_project p 
set p.attribute1 = p.attribute2

 

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Cause

PostgreSQL does not accept aliases, there the alias would need to be removed from the update statement.

Resolution

For example, modify the statement from:

update odf_ca_project p 
set p.attribute1 = p.attribute2

to

update odf_ca_project 
set attribute1 = attribute2