AnsweredAssumed Answered

Baseline Timeslice - which table does prj_object_id relate to ?

Question asked by alex.sinclair on Jan 27, 2011
Latest reply on Jan 28, 2011 by Jenn_Rinella
Hi

I am trying to use the data in our baseline timeslice - defined as against the Baseline Item.

Looking at the knowledge base suggests that prj_object_id should link to prj_baseline_details.id, but using this join only results in 183,033 rows in the results set out of 306,119 rows in the slice.

for example

select count(*)
from NIKU.PRJ_BLB_SLICES a1
where SLICE_REQUEST_ID=11

returns 306119

select count(*)
from NIKU.PRJ_BLB_SLICES a1
join niku.prj_baseline_details a2 on a1.prj_object_id = a2.id
where SLICE_REQUEST_ID=11

returns 183,033

Is this correct ? What do the other rows which don't join relate to ?

Outcomes