All records are not processed in GEL SCRIPT

Discussion created by deepakallscripts on Dec 16, 2013
Latest reply on Dec 18, 2013 by Dave

I have created custom Field in INV_INVESTMENTS with name as "TRACK_ASSIGN_ONLY". I am writing gel script which will set value of this field to "True" if that project is active.

My script works fine for 2-3 projects i.e i execute gel script with " code in ('9022','387030') ". But when i execute for all active records, It doesn't update any of records but process shows as completed successfully.

Any reason behind such behavior ? Is there any limit of records that can be processed in Gel script.


Here is my gel script content :


el:set asString="true"
  select="$auth/SOAP-ENV:Envelope/SOAP-ENV:Body/xog:SessionID/text()" var="sessionID"/>
  <!--Fetch rows from the excel sheet-->
      endpoint="http://localhost/niku/xog" var="runresult">
          xmlns:soapenv="" xmlns:xog="">
              <NikuDataBus xmlns:xsi="" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
                <Header action="write" externalSource="NIKU" objectType="project" version=""/>
<sql:query var="results" escapeText="false" dataSource="${ClarityDS}">
select code, name from inv_investments where code in ('9022','387030') and is_active = 1
<core:forEach items="${results.rowsByIndex}" var="row">
<core:set var="PROJECTCODE">${row[0]}</core:set>
<core:set var="PROJECTNAME">${row[1]}</core:set>
<Project active="true" name="${PROJECTNAME}" projectID = "${PROJECTCODE}" allowAssignedTasksOnly="1">