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.  

Joe

=========================================================================

<gel:script 
 xmlns:core="jelly:core" 
 xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary" 
 xmlns:sp="jelly:com.niku.union.gel.SOAPTagLibrary" 
 xmlns:sql="jelly:sql" 
>
<gel:setDataSource dbId="Niku" />
<core:set value="${gel_objectInstanceId}" var="objectid" />
 
<sql:update var="insert">
UPDATE prTask 
SET prPctComplete=1.00
WHERE
prTask.prProjectID = ?
 
<sql:param value="${objectid}"/>
 
</sql:update>
 
</gel:script>

Outcomes