I'm with CA PPM v15.2 SaaS and I want to know is there anyway to update a custom field by writing a Stored procedure. I want to populate a field based on value of other field(s). It's that we have any read access with SaaS DB, but is there any alternate way to populate a field based on certain criteria?
Since you are having read only access to DB, using a GEL based process could be one of the option, i.e. logic is build on the GEL script and the attribute is finally updated through a XOG.
Updating DB GEL script is not recommended and creation of stored procedure is not supported on SAAS db.
Hope this helps.