Search code examples
phpdoctrinedqlchainingdatabase-relations

Chaining related entity fields in DQL

Is something like this possible?

SELECT u FROM User WHERE u.address.city LIKE 'Gotham City'

I know it can be solved with JOIN-s, but im wondering if DQL supports this style of querying. Did not find anything in the official docs.

Solution

  • It's not possible, you have to join the entity as a specific identifier and check the address using the joined entity.