PATCH to get log reports

In order to get all the form submitted reports records within the dashboard, please do the hardcoding change described here below

NB: there's just one line to change and that's #63

PATCH details

file: /your DOCUMENT_ROOT/concrete/blocks/form/statistics.php:63

from: 58 public static function loadSurveys($MiniSurvey) 59 { 60 $db = Loader::db(); 61 62 return $db->query('SELECT s.* FROM '.$MiniSurvey->btTable.' AS s, Blocks AS b .. 63 WHERE s.bID=b.bID AND b.btID=bt.btID AND bt.btHandle = "form" AND EXISTS ( 64 SELECT 1 FROM CollectionVersionBlocks cvb 65 INNER JOIN CollectionVersions cv ON cvb.cID=cv.cID AND cvb.cvID=cv.cvID 66 INNER JOIN Pages p ON cv.cID = p.cID 67 WHERE cvb.bID=s.bID AND p.cIsActive=1 AND cv.cvIsApproved=1 68 )'); 69 } to: 58 public static function loadSurveys($MiniSurvey) 59 { 60 $db = Loader::db(); 61 62 return $db->query('SELECT s.* FROM '.$MiniSurvey->btTable.' AS s, Blocks AS b .. 63 WHERE s.bID=b.bID AND b.btID=bt.btID AND EXISTS ( 64 SELECT 1 FROM CollectionVersionBlocks cvb 65 INNER JOIN CollectionVersions cv ON cvb.cID=cv.cID AND cvb.cvID=cv.cvID 66 INNER JOIN Pages p ON cv.cID = p.cID 67 WHERE cvb.bID=s.bID AND p.cIsActive=1 AND cv.cvIsApproved=1 68 )'); 69 }

OK That's done,

after this you'll get to see all your forms reports records, even if they where submitted before having applied the patch

Enjoy