* hydra: only show current jobs in status overview of jobset page

Dependencies

• [2] 6QRHXIM3 * Speed up the jobset index page. Especially the query to get the
• [3] TJPIS3UP hydra: minor improvements in hydra ui
• [4] ZI535LI6 * hydra: 'new' UI for project/jobset/job/build
• [*] 3HZY24CX * Make jobsets viewable under

Change contents

• replacement in src/lib/Hydra/Controller/Jobset.pm at line 67
  [2.978]→[2.978:1218](∅→∅)
  − push(@select, "(SELECT buildstatus FROM BuildResultInfo bri NATURAL JOIN Builds b WHERE b.id = (SELECT MAX(id) FROM Builds t WHERE t.project = me.project AND t.jobset = me.jobset AND t.job = me.job AND t.system = '$system'))");
  [2.978]

  [2.1218]
  + push(@select, "(SELECT buildstatus FROM BuildResultInfo bri NATURAL JOIN Builds b WHERE b.id = (SELECT MAX(id) FROM Builds t WHERE t.project = me.project AND t.jobset = me.jobset AND t.job = me.job AND t.system = '$system' AND t.iscurrent = 1 ))");
• replacement in src/lib/Hydra/Controller/Jobset.pm at line 69
  [2.1250]→[2.1250:1483](∅→∅)
  − push(@select, "(SELECT b.id FROM BuildResultInfo bri NATURAL JOIN Builds b WHERE b.id = (SELECT MAX(id) FROM Builds t WHERE t.project = me.project AND t.jobset = me.jobset AND t.job = me.job AND t.system = '$system'))");
  [2.1250]

  [2.1483]
  + push(@select, "(SELECT b.id FROM BuildResultInfo bri NATURAL JOIN Builds b WHERE b.id = (SELECT MAX(id) FROM Builds t WHERE t.project = me.project AND t.jobset = me.jobset AND t.job = me.job AND t.system = '$system' AND t.iscurrent = 1 ))");