If the isBaseline column is true, it means that this data set should be used as a baseline for those that follow it chronologically for the same beam and machine until the next baseline or the last data set.
SELECT "institution"."name" as "Institution", -- anonymized name of institution "machine"."id" as "Machine", -- anonymized name of machine "machineType"."model", -- type of machine "multileafCollimator"."model" as "Collimator", -- HD or Millenium "output"."dataDate", -- time and date that data was collected -- "output"."analysisDate", -- time and date that data was analyzed "wedgePoint"."wedgeBeamName", -- name of wedge beam in RTPLAN "wedgePoint"."backgroundBeamName", -- name of background beam in RTPLAN "wedgePoint"."wedgeValue_cu", -- value of wedge point in CU : Calibrated Units "wedgePoint"."backgroundValue_cu", -- corresponding value of background field point in CU : Calibrated Units "wedgePoint"."percentOfBackground_pct", -- (wedgeValue_cu * 100) / backgroundValue_cu "wedgePoint"."isBaseline" -- If true, then this is to be used as a baseline. If not preceded -- chronologically by a baseline, then it will be used as a base even -- if it is false. Defaults to false. FROM public."wedgePoint", public."institution", public."machine", public."machineType", public."multileafCollimator", public."output" WHERE ("wedgePoint"."outputPK" = "output"."outputPK") AND ("output"."machinePK" = "machine"."machinePK") AND ("machine"."institutionPK" = "institution"."institutionPK") AND ("machine"."machineTypePK" = "machineType"."machineTypePK") AND ("machine"."multileafCollimatorPK" = "multileafCollimator"."multileafCollimatorPK") ORDER BY "institution"."name", "machine"."id", "output"."dataDate", "wedgePoint"."wedgeBeamName" ASC LIMIT 10;