Datagrid Choice Filter with choices from a Column

How is it possible to create a datagrid filter that contains distinct values from a column of the grid ?

Topic

[Artem LiubeznyiSpectator]

Hi Dima,

Not sure I correctly understand your question. Would you mind to provide a concrete use case you’d like to achieve? Thank you.

[Mike KudelyaParticipant]

Hi!

You should create custom provider, which return list of entities and configure QueryBuilder as you want.

PHP

<?php namespace Custom\Bundle\CustomBundle\Provider; use Doctrine\Bundle\DoctrineBundle\Registry; class ChoiceProvider { /** @var Registry */ protected $registry; /** * @param Registry $registry */ public function __construct(Registry $registry) { $this->registry = $registry; } /** * @return array */ public function getList() { $results = []; $rows = $this ->registry ->getManager() ->getRepository('Oro\Bundle\UserBundle\Entity\User') ->createQueryBuilder('u') ->getQuery() ->getResult(); foreach($rows as $entity) { $results[$entity->getId()] = $entity->getFirstname().' '.$entity->getLastname(); } return $results; } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

<?php   namespace Custom\Bundle\CustomBundle\Provider;   use Doctrine\Bundle\DoctrineBundle\Registry;   class ChoiceProvider {     /** @var Registry */     protected $registry;       /**      * @param Registry $registry      */     public function __construct(Registry $registry)     {         $this->registry = $registry;     }       /**      * @return array      */     public function getList()     {         $results = [];         $rows = $this             ->registry             ->getManager()             ->getRepository('Oro\Bundle\UserBundle\Entity\User')             ->createQueryBuilder('u')             ->getQuery()             ->getResult();           foreach($rows as $entity) {             $results[$entity->getId()] = $entity->getFirstname().' '.$entity->getLastname();         }           return $results;     } }

setup provider as service

YAML

parameters: oro_custom.provider.choice.class: Custom\Bundle\CustomBundle\Provider\ChoiceProvider oro_custom.provider.choice: class: %oro_custom.provider.choice.class% arguments: - '@doctrine'

1 2 3 4 5 6 7

parameters:     oro_custom.provider.choice.class: Custom\Bundle\CustomBundle\Provider\ChoiceProvider   oro_custom.provider.choice:         class: %oro_custom.provider.choice.class%         arguments:             - '@doctrine'

and configure your filter, something like this:

YAML

my-grid: filters: customField: type: choice label: label data_name: a.custom options: field_options: multiple: false choices: "@oro_custom.provider.choice->getList"

1 2 3 4 5 6 7 8 9 10

my-grid:         filters:                 customField:                     type: choice                     label: label                     data_name: a.custom                     options:                         field_options:                             multiple: false                             choices: "@oro_custom.provider.choice->getList"

[Dima MakarukParticipant]

Hi

Thank you for the quick reply. I think it won’t work with the provider. I need to get only the values/entities that are present in the datagrid resultset. But the filters are build before the datagrids datasource has the results.

[Mike KudelyaParticipant]

You want to put to filter values from certain column only from current page, right?

[Dima MakarukParticipant]

Yes,
from current datagrid.

[oro_newbieParticipant]

@Mike

I needed this and it’s very well explained. Thank you!

[oro_newbieParticipant]

@Mike

As an added question, is it possible to pass a parameter to the getList() function? In my case the parameter is the same that I’m passing to my where clause in my datagrid (defined under bind_parameters).

[anis.kaypooorParticipant]

Hi
I have similar issue. I have a datagrid which on one of its columns, choices data must be loaded dynamically. I need to load them conditional according to passed parameter.

YAML

columns: targetName: label: peymans.finance.xero_tracking_category.target_entity.label choices: "@custom.finance->getCategoryOptionTargetFields"

1 2 3 4

columns:             targetName:                 label: peymans.finance.xero_tracking_category.target_entity.label                 choices: "@custom.finance->getCategoryOptionTargetFields"

How can I pass parameter to method: “getCategoryOptionTargetFields()”?

Regards

[Andrey YatsenkoModerator]

Please have a look at datagrid listeners, they are more flexible than the configuration
https://github.com/oroinc/platform/blob/master/src/Oro/Bundle/DataGridBundle/Resources/doc/backend/events.md

[Author]

Replies