DoctrineのQueryBuilderでORDER BY Fieldを使用したい doctrine $partsNoArrayINT$owner_noINT $PartsArray = $PartsRepository->createQueryBuilder('p') ->add('where', $expr->andX( $expr->eq('p.owner_no', '?1'), $expr->in('p.parts_no', '?2') )) ->setParameters(array( 1 => $owner_no, 2 => $partsNoArray )) ->getQuery() ->getResult(); `ORDER BY field(p.parts_no,$partsNoArray)` $partsNoArray

stackoverflowDoctrine2MySQLFieldORDER BY

* Doctrine 2 mysql FIELD function in order by



polianychMr Hash

## Field

* <
* packagist beberlei/DoctrineExtensions



beberlei/DoctrineExtensionsstabledev-master


$ composer require beberlei/DoctrineExtensions:dev-master


##

Doctrine


$doctrineConfig = $this->em->getConfiguration();
$doctrineConfig->addCustomStringFunction('FIELD', 'DoctrineExtensions\Query\Mysql\Field');


Doctrine

Symfony


doctrine:
orm:
# ...
dql:
string_functions:
FIELD: DoctrineExtensions\Query\Mysql\Field


Symfony

## QueryBuilder


$qb
->select("r, field(r.id, :ids) as HIDDEN field")
->from("Entities\Round", "r")
->where("r.id IN :ids")
->setParameter('ids', $ids)
->orderBy("field");