AnsweredAssumed Answered

Script for date

Question asked by davidesky on May 30, 2012
Latest reply on May 30, 2012 by Gurjeet.S
Good Morning,
This is a part of our script to fill in a portfolio date in a project attribute.
We have not error, but the system does not write the date, can you help us? If we write a specific date the system make the operation and update the project attribute.

Thanks and Regards

<gel:formatDate format="yyyy-MM-dd'T'HH:mm:ss" stringVar="todate"/>

<sql:query var="a">
select portfoliomeetingdate
from odf_ca_portfolio
where id in (5015000)
</sql:query>
<core:forEach items="${a.rows}" var="qwe">
<core:set var="meeting_date" value="${qwe.prj_rev_meeting}"/>
</core:forEach>
<sql:query var="b">
select i.name, i.code
from pma_portfolio_contents p
left outer join inv_investments i on i.id=p.invest_id
left outer join odf_ca_project o on o.id=i.id
where portfolio_id in (5015000)
and proj_mng_type='control'
</sql:query>
<core:forEach items="${b.rows}" var="asd">
<core:set var="project_name" value="${asd.name}"/>
<core:set var="project_code" value="${asd.code}"/>
<gel:parse var="modifica_meeting_dates">
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
<Header action="write" externalSource="NIKU" objectType="project" version="13.0.0.7032"/>
<Projects>
<Project name="${project_name}"
projectID="${project_code}"
description="Descrizione inserita da XOG">
<CustomInformation>
<ColumnValue name="portfoliomeetingdate">${meeting_date}</ColumnValue>
</CustomInformation>
</Project>
</Projects>
</NikuDataBus>
</gel:parse>

</core:forEach>
</gel:script>

Outcomes