Jorge Reis asked 9 years ago
This work fine
$grid->select_command = "
SELECT DISTINCT a.id,
a.nome,
a.actividade,
(SELECT COUNT(*) FROM antp_pub_empresas_contactos b WHERE b.empresa_id = a.id) n_contactos
FROM
antp_pub_empresas a
WHERE a.id > 0
AND a.id NOT IN (SELECT c.empresa_id FROM antp_pub_empresas_conversacoes c WHERE c.pessoa_antp = 43)";
But this does not
$flt = " AND a.id NOT IN (SELECT c.empresa_id FROM antp_pub_empresas_conversacoes c WHERE c.pessoa_antp = 43) ";
$grid->select_command = "
SELECT DISTINCT a.id,
a.nome,
a.actividade,
(SELECT COUNT(*) FROM antp_pub_empresas_contactos b WHERE b.empresa_id = a.id) n_contactos
FROM
antp_pub_empresas a
WHERE a.id > 0 $flt";
WHY???
Jorge Reis answered 9 years ago
Solved. I had to change from POST to Get the method of the form where I have the controls with filter elements to pass to select_command
