Symfony forms an entity / document by sorting a property

Question

I use symfony forms to create a select-box with all my users. I show them by name, but I want to sort them alphabetically.

$builder->add('transferTo', 'document', [ 'class' => 'UserBundle:User', 'property' => 'fullname', 'label' => 'Overdragen aan', 'attr' => ['class' => 'form-control selectpicker'], 'label_attr' => ['class' => 'col-sm-2 control-label'], 'multiple' => false, 'required' => true ]); 

How can I sort users alphabetically by firstName?

Answer 1

You need to add queryBuilder to form parameters

 use Doctrine\ORM\EntityRepository; $builder->add('transferTo', 'document', [ 'class' => 'UserBundle:User', 'query_builder' => function(EntityRepository $repository) { return $repository->createQueryBuilder('u')->orderBy('u.fullname', 'ASC'); } 'property' => 'fullname', 'label' => 'Overdragen aan', 'attr' => ['class' => 'form-control selectpicker'], 'label_attr' => ['class' => 'col-sm-2 control-label'], 'multiple' => false, 'required' => true ]); 

I assumed that the name of the field in your entity is u.fullname