JIRA [IMG-301] BatchProfiler: Webpage showing incorrect information for batches with mulitple runs

[0x00b1]

From @thouis on November 23, 2011 20:50

Example: Batch 1484 -http://seaborgium/batchprofiler/cgi-bin/ViewBatch.py?batch_id=1484
Jobs for 195601 - 196000: SELECT job.job_id, job.run_id FROM run,job WHERE batch_id = 1484 AND bstart = 196001 AND bend = 196400 AND run.run_id = job.run_id;

Currently running as job 213871 on imageweb under priority queue, but listed as unknown job 9862736 on the webpage.

I think the problem is in RunBatch.py, line 125:

select run_id,batch_id,bstart,bend,status_file_name, (select max(job_id) from job j where j.run_id = r.run_id)

max(job_id) does not get the value needed. Perhaps add a timestamp field and order by that?

Original reporter: mbray
Jira link: https://jira.broadinstitute.org/browse/IMG-301
Assignee: leek

Copied from original issue: CellProfiler/CellProfiler#228