Project and Portfolio Management Practitioners Forum
cancel

How to make this SELECT from DB.

SOLVED
Go to solution
Highlighted
Korayk
Valued Contributor.

How to make this SELECT from DB.

Hi everybody,

I wanna make a select to find a field.

 

In attachments there is a field name is "Schulded work" in WBS . The problem is we assign more than one user to a task so I cannot find how many hours we assign a single user in SELECT. Because I use the wp_task_schedule table to get the schulded hours in a task.
I attach the image you can look .

 

2 REPLIES
Kerim KILIC
Honored Contributor.
Solution

Re: How to make this SELECT from DB.

hi,

 

wp_work_units the table you are looking for.

 

regards

Korayk
Valued Contributor.

Re: How to make this SELECT from DB.

Thanks for your help Kerim. It is very helpful for me.