TestStats for single Testplans at 1.4.8 not working - patched

[podskalsky]

There is a bug in your SQL statement! Single TestPlan statistics are not running at 1.4.8!

patched line 115 at stats.py:

sql = "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)

Regards, Andreas

[anonymous]

Ciao Andreas, well, thanks for catching this one!

I'll try to take a look at this tonight, in the meantime, would you take a look at the development version of 1.4.9 attached to ticket #8958 and let me know what you think?

Ciao, Roberto

[Roberto Longobardi]

Hi, the fix to this ticket is in the latest BETA 1.4.9 release, attached to #9287.

Actually there also is the need for updating the language catalogs. I have uploaded the modified versions on Transflex for anyone to contribute.

Refer to the ​forum post for details.

It would be great if you could take a tour and, besides looking at the new stuff, make sure nothing (big) is broken.

Thanks, ciao. Roberto

[podskalsky]

can't find this "bug" at BETA 1.4.9 release :-)

But: At "test activity trend" there is nothing displayed for test plans with "selected" test cases ("Only the Test Cases selected before")