Symfony forms entity/document sorting the property

Question

I'm using the symfony forms for creating a select-box with all my users. I display them by fullname, but 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 the users alphabetically on fullname of firstName?

It outputs a regular select with a few options (fullnames). But i want those names sorted alphabetically. — Mathias Dewelde
– Mathias Dewelde, Commented Mar 17, 2014 at 20:30

Javad · Accepted Answer · 2014-03-17 20:39:40Z

23

What you need is to add queryBuilder to the form params

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 the fieldname in your entity is u.fullname

answered Mar 17, 2014 at 20:39

Javad

4,4073 gold badges24 silver badges36 bronze badges

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

7 Comments

Mathias Dewelde Over a year ago

No errors but my select box isn't ordered either. (ASC nor DESC works)

Mathias Dewelde Over a year ago

Using ODM (MongoDB) use Doctrine\ODM\MongoDB\DocumentRepository; 'query_builder' => function(DocumentRepository $repository) { return $repository->createQueryBuilder('u')->sort('u.firstName', 'desc'); }, But still not sorting

Javad Over a year ago

Are you using MongoDB?

Mathias Dewelde Over a year ago

Yes i'm using MongoDB. I used sort instead of orderBy, used "document" instead of "entity" and Use DocumentRepository instead of EntityRepository. My select box isn't sorted but there aren't errors either.

Javad Over a year ago

I know the solution is adding the queryBuilder to form builder params either it's Doctrine or MongoDB; If you could find it it will help you

|

Collectives™ on Stack Overflow

Symfony forms entity/document sorting the property

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related