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