AnsweredAssumed Answered

Process Custom Gel Script - Not Working

Question asked by suhail.sayed on Dec 9, 2014
Latest reply on Dec 12, 2014 by suhail.sayed

Hi there,


I've developed a Process Custom Gel Script that deletes old entries from a Custom Clarity Object as given below:


<gel:script xmlns:core="jelly:core"

<gel:setDataSource dbId="Niku"/>

     <sql:update escapeText="False">

     delete from table

     where date between to_date ('01.01.2014', 'DD.MM.YYYY') and to_char (SYSDATE-16, 'DD.MM.YYYY')             





The Process executes fine without any errors, but, the old entries are not getting deleted. Any idea what may be wrong here? Thanks.