AnsweredAssumed Answered

GEL Script to update a table column based on conditions

Question asked by Mayank.Joshi on Mar 22, 2019
Latest reply on Mar 26, 2019 by roland.parrotte

Hello, 

 

Could some please provide me sample of a GEL script that updates a database column  based on Risks column value?

 

For example:

 

 

If (likelihood * consequence) <5 then update Table_X set String_Column_1 = “SAFE”

If (likelihood * consequence) is BETWEEN 5 and 10 then update Table_X set String_Column_1 = “ALERT”

If (likelihood * consequence) >10 then update Table_X set String_Column_1 = “DANGER”

 

I would appreciate,  if you can please advise.

 

Thanks and regards,

MJ

+61402251100

Outcomes