AnsweredAssumed Answered

TEAM BASELINE QUERY

Question asked by splogad on Apr 17, 2013
Latest reply on Apr 17, 2013 by another_martink
Hi!

I am trying to find a way to read via SQL team allocation values (slice) related to a given baseline.
I tried to follow the documentation (E/R Schema, etc..) but I am failing.

My intention is to calculate the difference between the current global allocation amount of days and the same information stored within a previous baseline.

I succesfully got the first information with this query
(SELECT SUM(s.slice)/8 hrs
FROM prj_blb_slicerequests pbs,
 prj_blb_slices s,
  prteam t,
  inv_investments p
WHERE s.slice_request_id= pbs.id
AND s.prj_object_id     = t.prid
AND t.prprojectid       = p.id
AND p.id                = i.id
AND s.slice_request_id  = 6
AND s.slice            <> 0
GROUP BY p.id
)
But I do not find slices value of the team in the baseline.

Do you have any ideas?
giacomo

Outcomes