DDC-2404: Filter using join tables #3016

New Issue

admin · 2026-01-22T14:09:56+01:00

admin commented

2026-01-22 14:09:56 +01:00

Originally created by @doctrinebot on GitHub (Apr 19, 2013).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user hosiplan:

Allow filters to add join tables to sql queries for filtering.

Let's have Brand entity, and BrandText entity. Text is localisation for each Brand. If there is no BrandText with bt.isPublic and bt.web_id = 123 I wanna filter it globally and not even allow to load Brand entity.

This cannot be solved by using DQL, because I need to affect lazily loaded associations, for example in templates

Accessing $product->brand-> in template should resolve to NULL, when there is no BrandText.isPublic = 1.

This could be solved by allowing filters to add joins to queries. Should I prepare a pull request?

Originally created by @doctrinebot on GitHub (Apr 19, 2013). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user hosiplan: Allow filters to add join tables to sql queries for filtering. Let's have Brand entity, and BrandText entity. Text is localisation for each Brand. If there is no BrandText with bt.isPublic and bt.web_id = 123 I wanna filter it globally and not even allow to load Brand entity. This cannot be solved by using DQL, because I need to affect lazily loaded associations, for example in templates Accessing $product->brand-> in template should resolve to NULL, when there is no BrandText.isPublic = 1. This could be solved by allowing filters to add joins to queries. Should I prepare a pull request?

admin added the New Feature label 2026-01-22 14:09:56 +01:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#3016