Clarity

Expand all | Collapse all

Change value with hierarchy

  • 1.  Change value with hierarchy

    Posted 07-03-2017 05:23 AM

    We have a case that we want to change the value of some custom attributes in the requirement object when the hierarchy change. Is it possible to do it?



  • 2.  Re: Change value with hierarchy

    Posted 07-03-2017 09:56 AM

    Can't you accomplish that via the process?

     

    NJ



  • 3.  Re: Change value with hierarchy

    Posted 07-04-2017 06:15 AM

    Yes, but we don't know when the hierarchy change to execute a process, we don't have an event. Is it something to know it?



  • 4.  Re: Change value with hierarchy

    Posted 07-04-2017 06:45 AM

    Guess, you need to check in the inv_hierarchies table for a record creation.

     

    Data in inv_hierarchies table 

    https://communities.ca.com/message/99340473 

     

     

    CA Clarity Tuesday Tip: Inv_Flat_Hierarchies

    https://communities.ca.com/message/23595052  

     

     

    INV_FLAT_HIERARCHIES or INV_HIERARCHIES which one to use? 

    https://communities.ca.com/message/241959162-invflathierarchies-or-invhierarchies-which-one-to-use 

     

     

     

    NJ



  • 5.  Re: Change value with hierarchy

    Posted 07-04-2017 09:35 AM

    Hi

     

    No, you cannot configure it as such from CA PPM studio. Either you create a gel script to run on regular basis (scheduled via job) or onDemand ... or you go for a DB customization like a SP or trigger.



  • 6.  Re: Change value with hierarchy

    Posted 07-24-2017 04:49 AM

    Hi RafaelGascaCalvo

     

    There are two table, I see that NJ also mentioned, INV_FLAT_HIERARCHIES or INV_HIERARCHIES which keeps the relation between the parent and child investment objects' stored in the database. Try to check if you can create a GEL Script in such a way that whenever the row for a Requirement object instance will get updated, a process will trigger and do the needful. I am not sure if that is possible and atleast you can give it a try. Hope that helps. 

     

    Thanks,

    Abhisek Dhar



  • 7.  Re: Change value with hierarchy

    Posted 07-24-2017 10:52 AM

    DB trigger is not advisable by CA. better to go with on-demand process based on hierarchy modified date (Incremental) to avoid the performance issue.