Extend ManyToMany – access associative table

Hi,

Is it possible to access and extend associative table on extended ManyToMany relation?

Example of use case:
BusinessUnit entity (extendable) has ManyToMany Language entity (configurable).
Update schema and clear / warmup entity-extend stuff and associative table is created e.g. “oro_rel_some_value” (columns are “business_unit_id”, “language_id”).

I would like to access and extend “oro_rel_some_value” and add some extra columns along with getters and setters, for example I would like for “oro_rel_some_value” look like follow:

| business_unit_id | language_id | my_extra_column_1 (bool) | my_extra_column_2 (string)

Any ideas how this can be achieved using platform native features?

I’m running platform 2.6.

Many thanks,
Marko

• This topic was modified 1 year, 7 months ago by  Marko.
• This topic was modified 1 year, 7 months ago by  Marko.

Topic

[Andrey YatsenkoModerator]

Hi Marko,

It’s not possible to add a field to the relation table.
But for this purpose instead of using relation, you could create some intermediate entity that will have a relation to both BusinessUnit and Language and will contain extra fields you need.

[MarkoParticipant]

Thanks @Andrey.

[Author]

Replies