Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Where can we find the individual task statuses and Summary tasks statuses

Highlighted
Shravan Kathuri
Senior Member

Where can we find the individual task statuses and Summary tasks statuses

Hi,
We are using PPM 7.5.

Can anyone know what is the table to get the individual task statuses and summary task statuses. I am assuming kdrv_states. Whether this table is applicable for all tasks or not.

Thanks
Shravan.
3 REPLIES
Semenov Alexand
Esteemed Contributor

Re: Where can we find the individual task statuses and Summary tasks statuses

Hi.
Run this and recive all statuses for all task levels
---------
select
ta.outline_level,tst.state_name

FROM

itguser.WP_TASKS ta,
itguser.WP_TASK_INFO ti,
itguser.KDRV_STATES tst
where
ta.task_info_id=ti.task_info_id
and ti.status = tst.state_id
group by

ta.outline_level,tst.state_name
--------

Good Luck
Shravan Kathuri
Senior Member

Re: Where can we find the individual task statuses and Summary tasks statuses

Hi Semenov Alexander,

Thanks for your response.

Can we use kdrv_states table for all the out line levels, i mean even for summmary task and normal tasks. Right now, i am reffering one of the validation "PM - Task Statuses" .Can we use this validation instead of kdrv_states table.

Thanks
Shravan.
Semenov Alexand
Esteemed Contributor

Re: Where can we find the individual task statuses and Summary tasks statuses

Hi.

Yes we can use kdrv_states for summmary task and normal tasks, About PM - Task Statuses do't know. May be this validation use select from this table.

//Add this to "OnDomLoad" event