AnsweredAssumed Answered

> symbol in GEL

Question asked by davidesky on Apr 19, 2012
Latest reply on May 16, 2012 by fpena
Hi, How can we use this symbol > in GEL?
We want to compare 2 values in the script below but we don't know which is the symbol we have to use. We have tried to use >, > but we have also the same error: BPM-0704..

<gel:script xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"
xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:sql="jelly:sql" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<gel:setDataSource dbId="niku"/>
<core:set value="${gel_objectInstanceId}" var="ideaID"/>

<sql:update>


update odf_ca_idea


set idea_start_period = case when to_number(substr(idea_st_per_date,7,4)) > to_number(substr(idea_fin_per_date,7,4)) then null


end,
idea_finish_period = case when to_number(substr(idea_st_per_date,7,4)) > to_number(substr(idea_fin_per_date,7,4)) then null


where id=${ideaID}

</sql:update>
</gel:script>

Thanks

Regards

Outcomes