sub queue_summary :Local :Path('queue-summary') :Args(0) {
    my ($self, $c) = @_;
    $c->stash->{template} = 'queue-summary.tt';

    $c->stash->{queued} = $c->model('DB')->schema->storage->dbh->selectall_arrayref(
        "select project, jobset, count(*) as queued, min(timestamp) as oldest, max(timestamp) as newest from Builds " .
        "where finished = 0 group by project, jobset order by queued desc",
        { Slice => {} });
}

[% WRAPPER layout.tt title="Queue summary" %]
[% PROCESS common.tt %]
[% IF queued.size == 0 %]
  <div class="alert alert-info">There are no pending builds.</div>
[% ELSE %]
  <table class="table table-striped table-condensed clickable-rows">
    <thead>
      <tr>
        <th>Jobset</th>
        <th># Queued</th>
        <th>Oldest queued</th>
        <th>Newest queued</th>
      </tr>
    </thead>
    <tdata>
      [% FOREACH j IN queued %]
        <tr>
          <td>[% INCLUDE renderFullJobsetName project=j.project jobset=j.jobset %]</td>
          <td>[% HTML.escape(j.queued) %]</td>
          <td>[% INCLUDE renderRelativeDate timestamp=j.oldest %]</td>
          <td>[% INCLUDE renderRelativeDate timestamp=j.newest %]</td>
        </tr>
      [% END %]
    </tdata>
  </table>
[% END %]
[% END %]

       uri = c.uri_for(c.controller('Root').action_for('queue'))

       uri = c.uri_for(c.controller('Root').action_for('queue_summary'))