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?
Can't you accomplish that via the process?
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?
Guess, you need to check in the inv_hierarchies table for a record creation.
Data in inv_hierarchies table
CA Clarity Tuesday Tip: Inv_Flat_Hierarchies
INV_FLAT_HIERARCHIES or INV_HIERARCHIES which one to use?
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.
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.
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.