diff options
| -rwxr-xr-x | server/scireserver.pl | 2 |
1 files changed, 1 insertions, 1 deletions
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 |