AnsweredAssumed Answered

GEL Script Doubt

Question asked by juan.segovia on Mar 6, 2013
Latest reply on Mar 7, 2013 by juan.segovia
Hi, I'm currently working on a process the contains in one step this GEL Script:

<gel:script
xmlns:sql="jelly:sql"
xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary">
<gel:setDataSource dbId="niku" var="dataSource"/>
<sql:update dataSource="${dataSource}">
UPDATE niku.ODF_CA_INV
set osde_continua = '1'
[size=5][color=#ff0000]where osde_inclu_plan = 'SI'[color][size]
and osde_plan_semestral=(select plan_admin.osde_plan_actual from niku.ODF_CA_OSDE_PLAN_ADMIN plan_admin where plan_admin.id=5000000 )
and osde_estado_req ='osde_implementado'
and osde_estado_req ='osde_anulado'
</sql:update>
</gel:script>

The problem I'm facing is that the [color=#ff0000]RED[color] attribute belongs to the ODF_CA_PROJECT table instead of the ODF_CA_INV

Can you please help me out with the correct syntax in order to make this GEL work? How do I reference the ODF_CA_PROJECT table?

Thanks,

Juan

Outcomes