{ join => 'aggregateconstituents_constituents', 

        { join => 'aggregateconstituents_constituents',

        $aggregates->{$agg}->{build} = 

        $aggregates->{$agg}->{build} =

        ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name, $c->stash->{job}->name]});

        ->search({}, {bind => [$c->stash->{jobset}->name, $c->stash->{job}->name]});

        ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name]});

        ->search({}, {bind => [$c->stash->{jobset}->name]});

makeQueries('ForJobset', "and project = ? and jobset = ?");
makeQueries('ForJob', "and project = ? and jobset = ? and job = ?");

makeQueries('ForJobset', "and jobset_id = (select id from jobsets j where j.name = ?)");
makeQueries('ForJob', "and jobset_id = (select id from jobsets j where j.name = ?) and job = ?");

        ->search({}, {bind => [$projectName, $jobsetName, $jobName]});

        ->search({}, {bind => [$jobsetName, $jobName]});