05-18-2019, 02:12 PM
I need to see the query that the filter is creating.
If you can, upload a screen shot of the filter definitions and the query being generated by adding
here: https://github.com/tsolucio/corebos/blob/master/include/home.php#L443
like this;
$queryGenerator->setFields($newFields);
$query = $queryGenerator->getQuery();
echo $query; die();
$count_result = $adb->query(mkCountWithFullQuery($query));
$noofrows = $adb->query_result($count_result, 0, 'count');
If you can, upload a screen shot of the filter definitions and the query being generated by adding
PHP Code:
echo $query; die();
here: https://github.com/tsolucio/corebos/blob/master/include/home.php#L443
like this;
$queryGenerator->setFields($newFields);
$query = $queryGenerator->getQuery();
echo $query; die();
$count_result = $adb->query(mkCountWithFullQuery($query));
$noofrows = $adb->query_result($count_result, 0, 'count');
Joe
TSolucio
TSolucio