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

How to make this SELECT from DB.

SOLVED
Go to solution
Highlighted
Korayk
Occasional 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
Frequent Visitor
Solution

Re: How to make this SELECT from DB.

hi,

 

wp_work_units the table you are looking for.

 

regards

Korayk
Occasional Contributor

Re: How to make this SELECT from DB.

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

//Add this to "OnDomLoad" event