Symfony - Doctrine createQueryBuilder from json_array

Question

Crete custom query in Symfony 4 and I use createQueryBuilder(). My entity have column price_ranges type type="json_array"

This data I store in this column

{
    "from": "10.10.2010", 
    "to": "10.20.2010", 
    "pricePerNight": 100,
    "minStay": 7
}

Want to query data by pricePerNight key in price_ranges column.

I create function but I have the following error:

[Semantical Error] line 0, col 41 near 'price_ranges': Error: Class App\Entity\House has no field or association named price_ranges

Here is my function. Where am I wrong?

public function findDataByPriceRange()
    {
        $qb = $this->createQueryBuilder('u');
        $qb->select('u')
            ->where('u.price_ranges LIKE :price_ranges')
            ->setParameter('pricePerNight', 100);
        return $qb->getQuery()->getResult();
    }

After I edit my function:

public function findVillasByPriceRange()
{
    $qb = $this->createQueryBuilder('u');
    $qb->select('u')
        ->where('u.priceRanges LIKE :priceRanges')
        ->setParameter('pricePerNight', 100);
    return $qb->getQuery()->getResult();
}

I get this error:

Invalid parameter: token pricePerNight is not defined in the query.

Yoann Kergall · Accepted Answer · 2019-05-13 12:01:48Z

2

You need to use the same parameter name in where() and setParameter() like this

->where('u.priceRanges LIKE :parameterName')
->setParameter('parameterName', 100);

answered May 13, 2019 at 12:01

Yoann Kergall

3,3425 gold badges26 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Symfony - Doctrine createQueryBuilder from json_array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related