Error when using 'filter_entity' about lexikformfilterbundle

[cedric-g]

Hi, what do you get if you dump $field and $fieldAlias variables just after the line $fieldAlias = substr($field, strpos($field, '.') + 1); ?

[fuser82]

Hi, I get this when I do var_dump
$field => string 'e._fieldName' (length=12)
$fieldAlias => string '_fieldName' (length=10)

in file Lexik\Bundle\FormFilterBundle\Filter\ORM\Filters\EntityFilter

[cedric-g]

Ok, I just made a quick test and I get the same error, it seems that Donctrine don't like parameters named like :_xxxxx, if I remove the _ to get a parameter named like :xxxxx it works. Maybe should add something like trim($fieldAlias, '_') before set the parameter.

[mrcmorales]

Hi,

This is resolved?

I'm filtering with filter_entity and obtain this error:

[Semantical Error] line 0, col 55 near 'jobCategories': Error: Invalid PathExpression. StateFieldPathExpression or SingleValuedAssociationField expected.

This is the query:

"SELECT e FROM CliCons\CoreBundle\Entity\User e WHERE e.jobCategories = :p_jobCategories"

Thanks

Regards

[mrcmorales]

Ping @cedric-g

Thanks :)

[cedric-g]

Hi, the error you get is not the same as fuser82 got. In your case Doctrine notice you that jobCategories is not a field in or a foreign key in the description of User table. I suppose jobCategories is a collection, soyou have to add a join to the target entity, then add your condition from the joined entity, so if I am right your query should be something like:

SELECT e FROM CliCons\CoreBundle\Entity\User e LEFT JOIN e.jobCategories jc WHERE jc.id = :jobCategoriesIds