Skip to content
Snippets Groups Projects

fix: only fetch relationshipts once in getList

Merged Frank Bessou requested to merge topic/default/relations-in-getlist into branch/default
1 unresolved thread

When an entitytype A has a relation rel with several target entity types (B and C) and when retrieving a list of A, the generated RQL looked like:

Any
    X, GROUP_CONCAT(Y), GROUP_CONCAT(Z) GROUPBY X
WHERE
    X rel Y,
    X rel Z

This lead to false results and performance issues. Lets assume that the relation has the same definition for several targets and generate the following RQL instead:

Any
    X, GROUP_CONCAT(Y) GROUPBY X
WHERE
    X rel Y,

Merge request reports

Pipeline #67130 passed

Pipeline passed for 8fb02689 on topic/default/relations-in-getlist

Approved by

Merged by François FerryFrançois Ferry 3 years ago (Jul 26, 2021 10:05am UTC)

Merge details

  • Changes merged into branch/default with 8fb02689.
  • Deleted the source branch.

Pipeline #71345 passed

Pipeline passed for 8fb02689 on branch/default

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
Please register or sign in to reply
Loading