Issue Feature Closed

#80380Missing Distinct / GroupBy option in Query

Benjamin Rannow 03/21/17, 16:23 updated 10/02/18, 11:00

Description

I encounter this Problem under Typo3 8.6.1

my Problem, I try to get objects with a condition which created joins.
my Result contains duplicate Records.

Example:
my Database contains 3 Records (CityA, CityB, CityC)
every city has 2 Pools of Zones which contains some Stores.

Some Stores are zone overlapping, which means,
CityA with innerZone1 contains StoreA and CityB with outerZone3 contains also StoreA

Now i want all Cities with a Specific store.
In our Example “Get all Cities which contains StoreA” will not only Result CityA, CityB …
the Actual Result is [CityA, CityA, CityB, CityB].

I have no chance to use an GroupBy or Distinct :(
See: https://github.com/brannow/frd_querybug/blob/master/Classes/Domain/Repository/CityRepository.php#L47-L59

For better understanding I created a proof of concept Extension for this behavior.
https://github.com/brannow/frd_querybug

Reviews 2