# Add the isCurrent column to Builds and use the obsolete Jobs.active to fill it in.

  update builds set isCurrent = 1 where id in (select max(id) from builds natural join (select distinct b.project, b.jobset, b.job, b.system from builds b join (select project, jobset, name from jobs where active = 1) j on b.project = j.project and b.jobset = j.jobset and b.job = j.name) b2 group by project, jobset, job, system);

sub filterInactiveJobs {
    my ($build) = @_;
    return $build->search(
        { active => 1 },
        { join => 'job'
        , '+select' => ["job.active"]
        , '+as' => ["active"]
        });
}

    $latest = filterInactiveJobs($latest)
        unless defined $c->stash->{showInactiveJobs};

            getChannelData($c, scalar(filterInactiveJobs($c->stash->{latestSucceeded})));

            getChannelData($c, scalar($c->stash->{latestSucceeded}));

    $c->stash->{showInactiveJobs} = 1;

    $c->stash->{activeJobs} = [$c->stash->{jobset}->jobs->search({active => 1})];

    $c->stash->{activeJobs} = [$c->stash->{jobset}->builds->search({isCurrent => 1}, {select => ["job"], distinct => 1})];

    my $activeJobs = "(select distinct project, jobset, job, system from Builds where isCurrent = 1 $constraint)";

             from Builds where finished = 1 $constraint group by project, jobset, job, system)

             from $activeJobs as activeJobs
             natural join Builds
             where finished = 1
             group by project, jobset, job, system)

             from Builds natural join BuildResultInfo
             where finished = 1 and buildStatus = 0 $constraint

             from $activeJobs as activeJobs
             natural join Builds
             natural join BuildResultInfo
             where finished = 1 and buildStatus = 0

    [% FOREACH j IN activeJobs %] [% INCLUDE renderJobName project=project.name jobset=jobset.name job=j.name %] [% END %]

    [% FOREACH j IN activeJobs %] [% INCLUDE renderJobName project=project.name jobset=jobset.name job=j.get_column('job') %] [% END %]

create index IndexBuildsByIsCurrent on Builds(isCurrent);