Clarity provides baseline slices, but it is unclear how to join them in custom queries? How do these tables relate and what fields do I need to join for my queries?
The prj_blb_slices table contain the following key references:
prj_object_id -- This is the id reference to the "parent object".
(i.e. prassignment.prid, prteam.prid or prj_baseline_details.id)
slice_request_id -- this is the
The prj_baseline_details table contains the following key references:
id -- this field uniquely identifies the baseline details record.
(It also would be the key reference for the prj_object_id for a baseline slice)
baseline_id -- this is the id of the baseline record (prj_baselines.id)
object_id -- this represents the id reference of the parent object.
Note: The object_type will determine the baseline type. i.e. for assignments, the object_type would be "ASSIGNMENT" and the object_id would be a reference to the assignment (prassignment.prid).
e.g. a sample "academic" example SQL Query fragment showing the joins for team information:
WHERE PRJ_BLB_SLICES.PRJ_OBJECT_ID = PRJ_BASELINE_DETAILS.ID
AND PRJ_BASELINE_DETAILS.OBJECT_ID = PRTEAM.PRID
AND PRJ_BASELINE_DETAILS.OBJECT_TYPE = 'TEAM'
For more information, please refer to user guide.
CLARITYKB, prj_baseline_details, baseline, slices, prj_object_id.