Pass a param to a grid query

Hi,

I have a positions entity that can belong to one or more categories. So on the view/update of a position I want to show a grid with the categories.

In my position view template I have the following:

{% set positionCategoriesWidget %} {{ oro_widget_render({ 'widgetType': 'block', 'url': path('position_widget_categories', {id: entity.id}), 'cssClass': 'inner-grid' }) }} {% endset %} {% set dataBlocks = dataBlocks|merge([ { 'title': 'Categories'|trans, 'subblocks': [ {'data' : [positionCategoriesWidget]} ] } ]) %}

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

{% set positionCategoriesWidget %}     {{ oro_widget_render({     'widgetType': 'block',     'url': path('position_widget_categories', {id: entity.id}),     'cssClass': 'inner-grid'     }) }}     {% endset %}     {% set dataBlocks = dataBlocks|merge([      {         'title': 'Categories'|trans,         'subblocks': [             {'data' : [positionCategoriesWidget]}         ]      }     ]) %}

In the widget template:

{{ dataGrid.renderGrid('position-categories-view-grid', { position: entity.id }) }}

1	{{ dataGrid.renderGrid('position-categories-view-grid', { position: entity.id }) }}

In the controller:
/**
* @Route("/widget/categories/{id}", name="position_widget_categories", requirements={"id"="\d+"})
* @Template()
*/
public function categoriesAction(Position $position)
{
return ['entity' => $position];
}

and in my categories grid i use the following query (in datagrid.yml):

query: select: - c.id - c.name from: - { table: Acme\Compman\Entity\Category, alias: c } where: and: - :position MEMBER OF c.positions

1 2 3 4 5 6 7 8 9

query:                         select:                             - c.id                             - c.name                         from:                             - { table: Acme\Compman\Entity\Category, alias: c }                         where:                             and:                                 - :position MEMBER OF c.positions

But the :position is never replaced with the position id. I’m a missing something?

Topic

[Alexandr SmagaParticipant]

Hi.

Yes, event listener should be registered to fill value from request to query.
SERVICE_ID:
class: %oro_datagrid.event_listener.base_orm_relation.class%
arguments:
- 'position' # YOUR QUERY PARAM NAME
- @oro_datagrid.datagrid.request_params
tags:
- { name: kernel.event_listener, event: oro_datagrid.datgrid.build.after.YOUR_GRID_NAME, method: onBuildAfter }


[sndplParticipant]

Thanks for the quick reply, it works now!!

[Author]

Replies