Dashboard widget not filtering

Hello, i have a datagrid widget on my dashboard for a custom entity, and i added some filters to the configuration.

My problem is that the configuration is not used to filter the grid ( the grid return all the records )

I read the documentation but i’m not sure if i’m missing something.

Do i need some add some extra services or it just word out of the box. How does the datagrid knows how to filter the query ? Can you provide a more complete example ?

Topic

[dzakharovParticipant]

Hi! The described message is, unfortunately, not enough to understand what is wrong. Could you please show me a more detailed about your datagrid? For provide you information about datagrid filters read https://oroinc.com/orocrm/documentation/current/cookbook/entities/datagrids#data-filters and more examples you can find https://github.com/oroinc/platform/blob/master/src/Oro/Bundle/FilterBundle/Resources/doc/reference/grid_extension.md

[jnetoParticipant]

thanks for your reply.

My grids work and the filters also, to list
I was trying to put the some filters on the dashboard widget configuration. They work fine and i can save the configuration. But the problem was that the configurations weren’t used to modified the grid query / results.

I think i need to use a datagrid listener

YAML

- { name: kernel.event_listener, event: oro_datagrid.orm_datasource.result.before.dashboard-client-grid, method: onResultBefore }

1	- { name: kernel.event_listener, event: oro_datagrid.orm_datasource.result.before.dashboard-client-grid, method: onResultBefore }

to apply my widget selected configurations and filter my grid query. I tested and it works.
Is this the way ?

Thanks

[msulimaModerator]

Hello, jneto.

Will be better to have configuration of your widget and datagrid to say exactly. But I think you should use another tag for your listener.

YAML

- { name: kernel.event_listener, event: oro_datagrid.datagrid.build.after.dashboard-client-grid, method: onBuildAfter }

1	- { name: kernel.event_listener, event: oro_datagrid.datagrid.build.after.dashboard-client-grid, method: onBuildAfter }

In this event you will have grid Datasource and you can apply additional where clauses for query builder of that datasource.

Also next documentation may be useful https://github.com/oroinc/platform/blob/master/src/Oro/Bundle/DataGridBundle/Resources/doc/backend/advanced_grid_configuration.md.

---

Check our free technical guide ”How to Build a Reliable and Secure Infrastructure for OroCommerce”.

[Author]

Replies