Null relation fields about lexikformfilterbundle HOT 4 CLOSED

Hi, I'm not sure to understand, do you need to filter Lesson entities with some null values ? or elements which are not related to a Lesson entity ?

from lexikformfilterbundle.

I think he needs that "lesson" be NULL, or the "empty_data" field is the problem? Cant imagine what are you trying to achieve.

from lexikformfilterbundle.

See. I have 2 entities with an OneToMany relation. Join column can be NULL. When I filter entity by join column, I can't get entities with a NULL join column, because there is no such row in filter_entity widget. When no filter is used, i receive all of this entities, but I want receive only with a NULL join column.

from lexikformfilterbundle.

Ok, so I think the easiest way to do it would be to override the EntityFilter listener to add a condition on the query builder in case of the value is null, so you can do something like:

namespace Custom\Filter\ORM\Filters;

use Doctrine\ORM\QueryBuilder;
use Lexik\Bundle\FormFilterBundle\Filter\ORM\Filters\EntityFilter as BaseEntityFilter;
use Lexik\Bundle\FormFilterBundle\Filter\ORM\Expr;

class EntityFilter extends BaseEntityFilter
{
    /**
     * {@inheritdoc}
     */
    protected function apply(QueryBuilder $queryBuilder, Expr $expr, $field, array $values)
    {
        if (null === $values['value']) {
            $queryBuilder->andWhere($expr->isNull($field));

            return;
        } 

        parent::apply($queryBuilder, $expr, $field, $values);
    }
}

Then override the service definition:

<service id="lexik_form_filter.entity" class="Custom\Filter\ORM\Filters\EntityFilter">
    <tag name="kernel.event_listener" event="lexik_filter.get" method="onFilterGet" />
</service>

from lexikformfilterbundle.