How to summarize original Estimate field value with Custom field value after update

[Ruslan Rekk (Ploskonos)]

Hi.

Could you please help me with following question:

I have some Custom fields (type of these fields: Number Field) to specify Estimation by role (dev,ba, qa). 

I want to set up Automation rule that will update Original Estimate field once any of these field updates.

For example, Original Estimate=0 and then I specify BA Effort Estimate as 1 - and I expect Original Estimate=1. Then I specify FE Effort Estimate as 2 - and I expect Original Estimate=3.

Is it possible to implement such Automation rule? 

Thanks in advance.

[Udo Brand · Accepted solution]

Hi Christian

I would delete it in the database as you stated by yourself:

delete from projectroleactor r 
where not exists (select u.id from cwd_user u where r.pid = u.id ) 
and r.pid is not null;

Note there are also entries in projectroleactor where pid is null ( no idea what reason for) but that's why I have this not null clause

Cheers Udo