AnsweredAssumed Answered

Dashboard - Labor Effort queries?

Question asked by svenvdc on Mar 3, 2008
Latest reply on Jul 26, 2013 by harlem-celepar
[left] Hi,[left]  [left] I would like to  use the "Remaining Allocation" value via a query on the Clarity database/datamart, does anyone know  how this could be retrieved or how I can find the queries behind the Labor Effort portlet?[left]  [left] I have a query that retrieves the total Allocation but I need to Remaing allocation, e.g.[left] SELECT
project_code,
project_name,
round(actual_hours/8,1) actual_h,
round(etC_hours/8,1) etc_h,
round(allocated_hours/8,1) alloc_h
FROM
NBI_PROJECT_CURRENT_FACTS
WHERE              
is_active = 1
AND project_code = '0927.51'
ORDER BY project_code
[left]  [left] Can anyone help?[left]  [left] Thanks,[left] Sven[left]

Outcomes