From 7beafd3d7f98786a99bb7c80899f11db58c7ae0a Mon Sep 17 00:00:00 2001 From: Andrew Gaffney Date: Tue, 1 Jan 2008 02:37:08 +0000 Subject: modify get_jobs query to make sure to get the latest job_history entry for the job svn path=/branches/new-fu/; revision=304 --- server/scireserver.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/server/scireserver.pl b/server/scireserver.pl index 4de6362..fd2da34 100755 --- a/server/scireserver.pl +++ b/server/scireserver.pl @@ -208,7 +208,7 @@ sub get_jobs { AND jobs.jobid = jobs_clients.jobid AND (job_conditions.deploy_time < now()) AND (job_conditions.expiration_time > now()) - AND job_history.statusid = '?' + AND (SELECT statusid FROM job_history WHERE jobid=jobs.jobid ORDER BY eventtime DESC LIMIT 1)=? ORDER BY jobs.priority,jobs.created EndOfQuery -- cgit v1.2.3-65-gdbad