5QE3TIHPUIKE54UTACN2CE2IZ6T6SNHSZNH5O7WWRCBHOTHFYO3AC HEZ2V5NULHSOTUWCRMMNMJGR4B4YCA4ICKYJPCDNUH2SXDQEJGTQC UWVMQIAC2HQNSG2JQOPZGUOCQ5V2JFP2F7RCTF3WJLK7NHSD5PAAC FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC P5X4P6VKS5CJOOLJRVL66GRJLDLVC3EKAVAHP2RJOXQJ7WTYAUBQC W6DC6K4INJQOJYR553ISCKZV7YIOGHEM3FZQPOLAPSZQ3KSJDMRQC 7YBYT2LQML2PKEO6UO4444AGSASS664UCDXW2YO3ALB7THQHCEBQC ZI535LI6PJMKSOBJE33B3RRZ5S2JVTR3XPUDTSXJW6BZNTAHS3GQC D5QIOJGPKQJIYBUCSC3MFJ3TXLPNZ2XMI37GXMFRVRFWWR2VMTFAC $c->stash->{jobsets} = [$c->stash->{project}->jobsets->search({},{ order_by => "name", "+select" => ["(SELECT COUNT(*) FROM Builds AS a NATURAL JOIN BuildSchedulingInfo WHERE me.project = a.project AND me.name = a.jobset AND a.isCurrent = 1 )", "(SELECT COUNT(*) FROM Builds AS a NATURAL JOIN BuildResultInfo WHERE me.project = a.project AND me.name = a.jobset AND buildstatus <> 0 AND a.isCurrent = 1 )", "(SELECT COUNT(*) FROM Builds AS a NATURAL JOIN BuildResultInfo WHERE me.project = a.project AND me.name = a.jobset AND buildstatus = 0 AND a.isCurrent = 1 )"], "+as" => ["nrscheduled", "nrfailed", "nrsucceeded"]})];
<td>[% IF j.get_column('nrscheduled') > 0 %]<img src="/static/images/question-mark.png" alt="Scheduled" />[% ELSIF j.get_column('nrfailed') == 0 %]<img src="/static/images/success.gif" alt="Succeeded" />[% ELSIF j.get_column('nrfailed') > 0 && j.get_column('nrsucceeded') > 0 %]<img src="/static/images/failure-some.gif" alt="Some Failed" />[% ELSE %]<img src="/static/images/failure.gif" alt="All Failed" />[% END %]</td>