AnsweredAssumed Answered

The xog in custom gel script does not update the records

Question asked by sparc.helpdesk on Nov 18, 2015
Latest reply on Nov 18, 2015 by sparc.helpdesk

When i want to xog in some data attributes of resource through a gel script, it does not update the records.

 

Please find below the gel script used with xml script:

 

Select CMN.USER_NAME ,CMN.FIRST_NAME,CMN.LAST_NAME,SRM.EXTERNAL_ID,srm.email,srm.unique_name

                    from cmn_sec_users cmn, srm_resources srm

                    where CMN.ID=SRM.USER_ID

                    and cmn.user_name='${row_cc[6]}'

                     </sql:query>

                               

                    <core:forEach items="${xog_res.rowsByIndex}" trim="true" var="xog_res">

                    <gel:log> through query '${xog_res[1]}'</gel:log>

                   

                    <gel:log> ${xog_res[4]} ${xog_res[0]} ${xog_res[5]}""${xog_res[2]}""${xog_cc}" </gel:log>

                    <gel:log> xogging the found records of the resources</gel:log>

                   

                    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_resource.xsd"><Header action="write" externalSource="NIKU" objectType="resource" version="14.2.0.237"/>

                    <Resources>                                   

                    <Resource externalId="${xog_res[3]}" resourceId="${xog_res[5]}" username="${xog_res[0]}">                   

                    <PersonalInformation emailAddress="${xog_res[4]}" firstName="${xog_res[1]}" lastName="${xog_res[2]}"/>                       

                    <OBSAssocs complete="false">                       

                    <OBSAssoc id="CCOBS" name="SC_Cost Center" unitPath="${xog_cc}"/>

                    </OBSAssocs>                   

                    </Resource>

                    </Resources>

                   </NikuDataBus>

 

 

Please let me know the reason behind this

 

Regards,

Jerish

Outcomes