Filters for dynamic columns DataGrid

Hello everyone
I need to add filter for dynamic column in my DataGrid. The column and it’s filter is added to my DataGrid by listener on the “onBuildAfter”, and the data is added in the “onResultAfter”.
Codes:

PHP

/** * @param BuildAfter $event */ public function onBuildAfter(BuildAfter $event) { //$this->repository = $this->entityManager->getRepository('OroCRMCallBundle:Call'); $config = $event->getDatagrid()->getConfig(); $config->offsetUnsetByPath("[filters][columns][day_number]"); $config->offsetAddToArrayByPath("[filters][columns]", ['day_number' => array()]); $config->offsetAddToArrayByPath("[filters][columns][day_number]", ['label' => 'Subject List']); $config->offsetAddToArrayByPath("[filters][columns][day_number]", ['type' => 'number']); $config->offsetAddToArrayByPath("[filters][columns][day_number]", ['data_name' => 'day_number']); $config->offsetAddToArrayByPath("[filters][columns][day_number]", ['enabled' => true]); $config->offsetAddToArrayByPath("[filters][columns][day_number]", ['translatable' => true]); return; }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

/**      * @param BuildAfter $event      */     public function onBuildAfter(BuildAfter $event)     {         //$this->repository = $this->entityManager->getRepository('OroCRMCallBundle:Call');         $config = $event->getDatagrid()->getConfig();         $config->offsetUnsetByPath("[filters][columns][day_number]");           $config->offsetAddToArrayByPath("[filters][columns]", ['day_number' => array()]);           $config->offsetAddToArrayByPath("[filters][columns][day_number]", ['label' => 'Subject List']);         $config->offsetAddToArrayByPath("[filters][columns][day_number]", ['type' => 'number']);         $config->offsetAddToArrayByPath("[filters][columns][day_number]", ['data_name' => 'day_number']);         $config->offsetAddToArrayByPath("[filters][columns][day_number]", ['enabled' => true]);         $config->offsetAddToArrayByPath("[filters][columns][day_number]", ['translatable' => true]);             return;       }

Thanks :)
Shomeis

Topic

[Yevhen ShyshkinParticipant]

Hello Shomeis.

If you want to add column and filter it is better to use onBuildBefore event. There is another issue though – filters (and sorters) work on the main datagrid query only. In other words, it is not enough to mix your data using onResultAfter event to allow filter work with it – you have to make sure that this data is presented in the DB query.

Usually it’s done using additional join to a required entity and added required parts to select, columns, filters and sorter sections of the datagrid. Here is an example: https://github.com/oroinc/orocommerce/blob/3.1.0-rc/src/Oro/Bundle/TaxBundle/EventListener/TaxCodeGridListener.php#L38-L47

Please let me know if you still have some questions.

[Author]

Replies