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"
                 xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
                 xmlns:sql="jelly:sql">

<gel:setDataSource dbId="Niku"/>

     <sql:update escapeText="False">
     <![CDATA[

     delete from table

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

      ]]>

     </sql:update>

</gel:script>

 

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

 

Suhail.

Outcomes