Geek asks and answers

How to filter multiple fields in one filter?

Can I create a search filter for searching not from one field, but from CONCAT(name, description)?

protected function configureDatagridFilters(DatagridMapper $datagridMapper)
{
    $datagridMapper->add('search');
}
+5
source share
3 answers

I found a solution with type doctrine_orm_callback

protected function configureDatagridFilters(DatagridMapper $datagridMapper)
{


    $datagridMapper
        ->add( 'text', 'doctrine_orm_callback', array(
            'callback' => array($this, 'getSearchFilter'),
            'field_type' => 'text'
        ) );
}

public function getSearchFilter($queryBuilder, $alias, $field, $value) {
    if (!$value['value']) {
        return;
    }

    $exp = new \Doctrine\ORM\Query\Expr();
    $queryBuilder->andWhere($exp->like($exp->concat($alias.'.name', $alias.'.description'), $exp->literal('%' . $value['value'] . '%')));

    return true;
}
+5
source

Great solution from @Liutas!

If you want to use your concat as a workaround to search for multiple fields, you can use this code:

public function getFullTextFilter($queryBuilder, $alias, $field, $value)
{
    if (!$value['value']) {
        return;
    }

    $queryBuilder->andWhere($queryBuilder->expr()->orX(
        $queryBuilder->expr()->like($alias.'.name', $queryBuilder->expr()->literal('%' . $value['value'] . '%')),
        $queryBuilder->expr()->like($alias.'.description', $queryBuilder->expr()->literal('%' . $value['value'] . '%')),
        $queryBuilder->expr()->like($alias.'.anotherfield', $queryBuilder->expr()->literal('%' . $value['value'] . '%'))
    ));

    return true;
}
+2
source

Based on @webDEVILopers answer, here is a generic class that can be used in any field:

use Doctrine\ORM\Query\Expr;
use Sonata\AdminBundle\Datagrid\ProxyQueryInterface;
use Sonata\DoctrineORMAdminBundle\Filter\BooleanFilter;

class MultiStringFilter extends BooleanFilter
{
    /**
     * @param string $field should be in the form field1-field2-…-fieldn
     */
    public function filter(ProxyQueryInterface $queryBuilder, $alias, $field, $data)
    {
        $fields = explode('-', $field);
        $filterActive = $data['value'];
        if ($filterActive === null) {
            return;
        }

        $subConditions = [];
        foreach ($fields as $field) {

            $subConditions[] = $queryBuilder->expr()->like(
                "LOWER($alias.$field)",
                $queryBuilder->expr()->literal('%' . strtolower($data['value']) . '%')
            );
        }

        if (count($subConditions) > 1) {
            $queryBuilder->andWhere(new Expr\Orx($subConditions));
        }
    }
}
+1
source

More articles:


All Articles