QMC6IMJQ3CTMLLEERF5YT7JS3RJW4UJ2BKEJA43WRQ5OL72G6ZMAC
{ where => \ ("(finished = 0 or (me.stoptime >= " . (time() - $windowSize) . "))")
{ where => \ ("(finished = 0)")
, join => 'buildsteps'
, select => \ "sum(coalesce(buildsteps.stoptime, ${\time}) - buildsteps.starttime)"
, as => "sum" })->single->get_column("sum") // 0;
$timeSpent += $jobset->builds->search(
{ },
{ where => \ ("(me.stoptime >= " . (time() - $windowSize) . ")")