Project baseline - is there a way to schedule a baseline?

[skendy]

Hi,

I have been asked if there is a way to schedule (or an automatic procedure) a baseline in the project related lists?

I was thinking a kind of any specified date or time to have a 'snapshot' of the project tasks state and actual dates and progress.

I suggested scheduling reports, but it is not the same thing...

Thank you for any help,

Skender

[Kalaiarasan Pus · Accepted solution]

Change this line as per your requirement

projects.addEncodedQuery("active=true^state=1");

Baselines parent table is 'planned_task_baseline'. The script is for creation of baselines . You may run a scheduled report to automatically retrieve the data

[skendy]

I execute the schedule job for all active projects with no errors.

I have active 71 project and so I should except 71 baselines, right?

...

var projects = new GlideRecord("pm_project");

projects.addEncodedQuery("active=true");

...

But when I run the report on planned_task_baseline table with no filters at all, I get as a result the old baselines (old date) and NO new ones created by the scheduled job right now...

What should I modify?

Thanks,

Skender  

[Kalaiarasan Pus]

active=true query should work for all the active projects.

[skendy]

I tested the scheduled job also with other types of addEncodedQuery filters,

but it seems that it is not populating the planned_task_baseline table. And when I create manually a new baseline for a project I see it in the updated report...

When I see the system log -> events it is executed correctly.

I am thinking what is going wrong...

[skendy]

I am really sorry Kalai. IT WORKS PERFECTLY!

I had not put the final () in the scheduled job!

Grazie mille!

Skender