I would like to know if there is a possibility to lock an attribute on the task object in all the tasks of all existing projects. I was able to do this in the studio side, but it locks only object instance and not all instances (all tasks on all projects).
In this discussion: https://communities.ca.com/thread/10044444, there was a solution to create a GEL SCRIPT which allows to insert in the table ODF_LOCKED_ATTRIBUTES lines that I want to lock. So I thought to do this script just to test if it works:
<gel:script xmlns:core="jelly:core" xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:sql="jelly:sql">
<gel:setDataSource dbId="Niku"/>
<sql:update>
insert into odf_locked_attributes
(ID,
OBJECT_CODE,
ODF_PK,
ATTRIBUTE_CODE,
CREATED_DATE,
CREATED_BY,
LAST_UPDATED_DATE,
LAST_UPDATED_BY)
values
(ODF_LOCKED_ATTRIBUTES_S1.nextval,
'task',
500789,
'xdf_att_fsp',
sysdate,
1,
sysdate,
1)
</sql:update>
</gel:script>
But the problem is that the process does not execute, it's stucked in the 'start' step. did I done something wrong? i think if this method works, I can make a loop on this sequence to insert all the lines of the attribute in order to lock them.
Any help/thoughts??
Regards
Amine Tben