AnsweredAssumed Answered

Process with Gel Script - Error

Question asked by Patricio_1979 on Jun 10, 2015
Latest reply on Jun 11, 2015 by Patricio_1979

Hello everybody, I contact with you because I have a problem with a process that use  the following gel-script in a step and the result is ERROR!!!

If someone experiment an similar error please tell me the solution.

 

This is the GEL:

<gel:script xmlns:core="jelly:core" xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary" xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"

  xmlns:sql="jelly:sql" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <gel:setDataSource dbId="niku" var="dataSource"/>

  <sql:update dataSource="${dataSource}">

UPDATE niku.INV_INVESTMENTS

set STATUS = 'APPROVED'

where id in( select odf_ca_project.id

from niku.odf_ca_project

where osde_inclu_plan = 'SI'

and osde_continua = '1'

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>


I need to set the value "Approved" in the field "STATUS" when the projects have these parameters:

 

where id in( select odf_ca_project.id

from niku.odf_ca_project

where osde_inclu_plan = 'SI'

and osde_continua = '1'

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')

 

Regards.

Patricio.

Outcomes