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