How to join two tables defined in two different bundles?

I want to left join two tables in order to show the details in a datagrid. These tables are belonging to two different bundles.

Entity : Student
Table 1: student
– primary key : id
– foreign key : class_id

Entity : Class
Table 2: class
– primary key : id

A class can have many students. (one to many relationship)

Any suggestions would be appreciated.

Topic

[ibratsiloModerator]

Hi, thanks for your question.

You need to add join part to your datagrid.yml configuration. Here is an example in documentation: https://oroinc.com/orocrm/doc/2.6/dev-guide/entities/datagrids#data-source

1. In case if your bundles know about each other your join may be like this (from student side):

YAML

join: left: - { join: student.class, alias: class }

1 2 3

join:      left:          - { join: student.class, alias: class }

Considering that you created entities with the correct mappins. More details can be found here –
https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/reference/unitofwork-associations.html
https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/reference/association-mapping.html#one-to-many-bidirectional

2. If only bundle which holds Class entity should know about students you have to use join table. More details is here –
https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/reference/association-mapping.html#one-to-many-unidirectional-with-join-table

[Author]

Replies