Details
Description
entity A have many entity B
If DQL is something like "select A, B from A join B order by A.field1, B.field2"
Then Paginator retrieve different Id by a query like :
"select distinct a.id, a.field1, b.field2 from ( ....) order by a.field1 ASC , b.field2 ASC limit 15 offset 0"
so, if a entity A have 20 entity B (and these sub-entity have all a different b.field2) then there's only 1 A retrieved
Activity
Marco Pivetta
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Issue Type | Bug [ 1 ] | Improvement [ 4 ] |
| Security | All [ 10000 ] | |
| Priority | Major [ 3 ] | Minor [ 4 ] |
Marco Pivetta
made changes -
| Comment | [ Arbitrary joins are not supported by the paginator ] |