AnsweredAssumed Answered

GEL Script to Update Task Percent Complete

Question asked by JoeSchreurs on Feb 13, 2014
Latest reply on Feb 21, 2014 by JoeSchreurs

Hi Everyone,

There has been a lot of great information in this group, and it has helped me a ton.  I have run into a snag where we are trying to build a process to allow managers to initiate close processes within the project.   My specific issue is driving me crazy, since I am able to update the Task Status to Completed, but I cannot update the % Complete to 100%.  Am I missing a constraint somewhere that is preventing me from updating the % from the Task table?   Thanks for any assistance!

My ${gel_objectInstanceId} is thisProject so I should be receiving the ProjectID, as email notifications are correctly displaying the right key.  



<gel:setDataSource dbId="Niku" />
<core:set value="${gel_objectInstanceId}" var="objectid" />
<sql:update var="insert">
UPDATE prTask 
SET prPctComplete=1.00
prTask.prProjectID = ?
<sql:param value="${objectid}"/>