id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
9510,TestStats for single Testplans at 1.4.8 not working - patched,podskalsky,seccanj,There is a bug in your SQL statement!\r\nSingle TestPlan statistics are not running at 1.4.8!\r\n\r\npatched line 115 at stats.py:\r\n\r\nsql = "SELECT COUNT(*) FROM testcasehistory th1_ (SELECT id_ planid_ max(time) as maxtime FROM testcasehistory WHERE planid = '%s' AND time > %s AND time <= %s GROUP BY '''planid_''' id) th2 WHERE th1.time = th2.maxtime AND th1.id = th2.id AND th1.planid = th2.planid AND th1.status = '%s'" % (testplan_ to_any_timestamp(from_date)_ to_any_timestamp(at_date)_ status)\r\n\r\nRegards_\r\nAndreas,defect,closed,highest,TestManagerForTracPlugin,blocker,fixed,,,0.12