Clarity

 View Only
  • 1.  Update custom field in DB

    Posted Aug 10, 2017 12:15 PM

    Hi,

     

    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? 



  • 2.  Re: Update custom field in DB

    Posted Aug 10, 2017 12:37 PM

    Hi Monica,

     

    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.

     

    Regards,

    Samik