AnsweredAssumed Answered

Gel Writing Issue

Question asked by Avik.Roy on May 25, 2017
Latest reply on May 26, 2017 by Dave_3.0

Hi All,

I am trying to write some data (around 13-14 columns) related to actuals on a csv file via gel scripting in a process

It is writing all data except writing three fields which is for Timesheet Start Date, End Date and Actual Hours. These three columns are coming blank. Even when i moved their sequence from end to between nothing happens but the sql is generating the data and there is no issue with it for those columns

 

I am attaching the write part for your check if you find any issues in it

 

  <!--Iterate rows in query and create rows in file-->
    <core:forEach items="${result.rows}" trim="true" var="row">
      <file:line>
        <file:column value="&quot;${row.EID.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.RF.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.RMF.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.PRF.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.PTN.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.DPC.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.FCN.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.INC.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.INN.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.CAR.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.MEN.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.TPRS.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.TPRF.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.TEH.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.PRN.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.CPRN.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
        <file:column value="&quot;${row.TSN.replaceAll('&quot;', '&quot;&quot;')}&quot;"/>
      </file:line>
    </core:forEach>
    <!--Flush buffer and close file handle-->
  </file:writeFile>

Outcomes