Skip to content

query web service fails on count(*)

Hi @prasad using php 8.3 and vtiger 8.4 web services, query "select count(*) from Leads" returns empty result

the problem is in webservice vtigerModuleOperation.php

in public function query you should do this check if it's a count query, otherwise vtiger always return empty results

if(!array_key_exists("count(*)", $row)){

if(!isset($row[$tableIdColumn]) || !$meta->hasPermission(EntityMeta::$RETRIEVE,$row[$tableIdColumn])){

continue;

}}