Have you ever opened up Clarity and found things awry? Maybe someone changed your project hierarchy? Today's Learn with Rego helps you sleuth out the person responsible and block some of the others.
Please feel free to comment on any alternative answers you've found. At Rego, we always love your input.
Learn with Rego | Q&A
1. Who changed the calculation on this attribute?
2. Help. People keep changing my project's sub-projects!
3. Who initiated that Process?
How can you find out who changed the calculation on an attribute, like the one below?
You can do a SQL trace with the following query:
select oca.*, ofe.expression aggregated_filter from odf_custom_attributes oca left outer join odf_filter_expressions ofe on ofe.object_instance_id = oca.id and ofe.object_code = 'ODF_AGGREGATED_ATTRIBUTE' where 1 = 1 and internal_name = 'cop_overall_status' and object_name = 'cop_prj_statusrpt'
Help. People keep changing my project's sub-projects! Can we hide the button, so they can't mess with the hierarchy (parent/child/grandchild)?
button[onclick*="navigateToURL('nu?action=projmgr.selectSubProjects'"]{ display:none !important; } button[onclick*="submitForm('subProjectsList.xsl','projmgr.removeSubProjects'"]{ display:none !important; } button[onclick*="submitForm('subProjectsList.xsl','projmgr.setSubProjectsReadOnly'"]{ display:none !important; }
Who initiated that process via GEL?
<!-- Get Initiating User --> <sql:query var="init_user"> select csu.user_name p_init from bpm_run_processes p JOIN cmn_sec_users csu on p.initiated_by = csu.id where p.id = ${gel_processInstanceId} </sql:query> <core:set value="${init_user.rows[0].p_init}" var="p_init"/>