Clarity

I want to change the is_active field of the inv_investment table for the inactive projects of the year 2017. This I want to do with XOG- Could you guide me with this?

Hi RnFernandez ,

You can use Gel script with some logic to achieve your xogging, however I’m not sure on your requirement, so if you can give me a bit more information then we might able to suggest you something. 

Regards,

Prashank Singh

Hi Prashank, basically what I have detailed before is what I have to do.
Please tell me what I should inform so you can help me.
I await your news
Thank you very much in advance.

Hi,

Agree with Prashank, GEL script or Mail-merge can be used can be used to update the Status of Project 

Regards

Gaurav 

Hi 

Before you change the project to inactive, you need to change "Financial Status" of project to "Hold" or "Closed".

If the "Financial Status" is Open, you will not able to change the project to inactive.

Regards,

Shoichi

thank you very much shoichi

HELP

I am using prj_projects_read.xml to select a group of projects with XOG.

These two filters work

<Filter name = "active" criteria = "EQUALS"> true </ Filter>
<Filter name = "finish" criteria = "BEFORE"> 2018-01-01 </ Filter>

But instead of "finish" the client needs to use a custom field "closing_date" of the table odf_ca_inv

Is there any way to relate the prj_projects_read.xml filters to the mentioned field / table?

Hello,

You can use the project Custom attribute name that is defined in Project Object instead of Finish.

Thank you, this was the solution.