AnsweredAssumed Answered

How to lock an attribute on all tasks in projects?

Question asked by Calemirou on Mar 23, 2017
Latest reply on Mar 24, 2017 by suhail-sayed

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

Outcomes