Table always list all results even with a where in source (Doctrine)

[Nyl000]

Here is my code:

$id = (int) $this->params()->fromRoute('id', 0); $queryBuilder = $this->getEntityManager()->createQueryBuilder() ->add('select', 'q') ->add('from', $this->entityNamespace . ' q') ->leftJoin('q.customersInfos', 'b') ->leftJoin('b.customer', 'c') ->where('c.id = '.$id);

        $table = new ProductTable($this->getTranslator());
        $table
            ->setSource($queryBuilder)
            ->setParamAdapter($this->getRequest()->getPost());
        return $this->htmlResponse($table->render());

(a $query->getQuery()->getSQL() typed in phpmyadmin work as I want, but the table always show all my product table..)

Any ideas ??

[olekhy]

try andWhere

[Nyl000]

olekhy: it doesn't work. Same request generated, same result :s

[Nyl000]

Ok, solved this by passing the source in the table constructor..

//in controller:

$table = new ProductTable($this->getTranslator(), $queryBuilder);

//in table class:

function __construct(Translator $translator, $queryBuilder = null) { // .... $this->setSource($queryBuilder); // .... }

So the problem is when the setSource method si called I guess..