Oro datagrids: query_builder as data-source > unable to register service

Hi there,

I am trying to use query_builder-approach to ‘feed’ my datagrid with data according to the docs:
https://github.com/oroinc/platform/blob/master/src/Oro/Bundle/DataGridBundle/Resources/doc/backend/datagrid.md

However, I am unable to register the necessary service:

An exception has been thrown during the rendering of a template (“You have requested a non-existent service “oro_user.repository”.”) in OroUIBundle:actions:index.html.twig at line 50.

my datagrids.yml

PHP

users-grid: source: type: orm query_builder: "@oro_user.repository->findEnabledUsersQB" columns: id: label: ID name: label: Name createdAt: label: oro.ui.created_at frontend_type: datetime updatedAt: label: oro.ui.updated_at frontend_type: datetime

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

users-grid:         source:             type: orm             query_builder: "@oro_user.repository->findEnabledUsersQB"           columns:             id:                 label: ID             name:                 label: Name             createdAt:                 label: oro.ui.created_at                 frontend_type: datetime             updatedAt:                 label: oro.ui.updated_at                 frontend_type: datetime

(OroUserBundle/Repository/UserRepository::findEnabledUserQB)

my services.yml

PHP

parameters: oro_user.repository.class: Oro\Bundle\UserBundle\Entity\Repository\UserRepository services: oro_user.repository: class: '%oro_user.repository.class%' arguments: - '@doctrine.orm.entity_manager'

1 2 3 4 5 6 7 8 9

parameters:   oro_user.repository.class: Oro\Bundle\UserBundle\Entity\Repository\UserRepository    services:     oro_user.repository:     class: '%oro_user.repository.class%'     arguments:       - '@doctrine.orm.entity_manager'

I assume, arguments are not fitting. Or should I tag the service in some way?

What I am doing wrong?

Thanks
Frank

Topic

[Andrey YatsenkoModerator]

No need to tag the service, but if you want to expose the repository as a service, you have to define the factory instead:
See an example: https://github.com/oroinc/platform/blob/master/src/Oro/Bundle/CronBundle/Resources/config/services.yml#L75-L81

[FrankParticipant]

Hi Andrey,

first I rejoiced, but … Oro still does not recoginse the service. I tried the following versions, using factory-attribute:

PHP

oro_user.repository: class: '%oro_user.repository.class%' factory: ['Oro\Bundle\UserBundle\Entity\User', getRepository] # arguments: # - '@doctrine.orm.entity_manager'

1 2 3 4 5

oro_user.repository:     class: '%oro_user.repository.class%'     factory: ['Oro\Bundle\UserBundle\Entity\User', getRepository] #    arguments: #      - '@doctrine.orm.entity_manager'

PHP

oro_user.repository: class: '%oro_user.repository.class%' factory: ['Oro\Bundle\UserBundle\Entity\User', getRepository] arguments: - '@doctrine.orm.entity_manager'

1 2 3 4 5

oro_user.repository:     class: '%oro_user.repository.class%'     factory: ['Oro\Bundle\UserBundle\Entity\User', getRepository]     arguments:       - '@doctrine.orm.entity_manager'

PHP

oro_user.repository: class: '%oro_user.repository.class%' factory: ['@doctrine', getRepository] arguments: - '@doctrine.orm.entity_manager'

1 2 3 4 5

oro_user.repository:     class: '%oro_user.repository.class%'     factory: ['@doctrine', getRepository]     arguments:       - '@doctrine.orm.entity_manager'

PHP

oro_user.repository: class: '%oro_user.repository.class%' factory: ['@doctrine', getRepository] arguments: - '@doctrine.orm.entity_manager' - 'Oro\Bundle\UserBundle\Entity\User'

1 2 3 4 5 6

oro_user.repository:     class: '%oro_user.repository.class%'     factory: ['@doctrine', getRepository]     arguments:       - '@doctrine.orm.entity_manager'       - 'Oro\Bundle\UserBundle\Entity\User'

None of them is working …

Thank you for help!

Kind regards
Frank

[FrankParticipant]

Hi Oro-team,

could you have a look on my unresolved problem concerning exposing repository as a service above, please. Would ber very kind. Thank you.

Frank.

[Author]

Replies