Issue Feature Closed

#55959Joins on SubClasses

Philipp Wrann 02/13/14, 14:36 updated 02/06/21, 20:58

Description

The Typo3DbBackend Class does not respect the possibility you join a table with the same table. This happens if you use SubClasses which are connected.

An alias should be taken there. I managed to make this work, but its just a very quick and dirty solution. I replaced the backend by a patched, its attached to this issue. Just ignore the other modifications.

The approach is the usage of alias and a additional param in the function for the parent.

The problem occured when i made a query like this

->contains(location.rootline,uid)

where the aggregate i want to filter is a SubClass of the same class my location is a subClass of. So the join looked like

select * from tx_ex_domain_model_object left join tx_ex_domain_model_object on ….

Because SuperClass and SubClasses are a feature of extbase this is a must-have.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.