I have a 3 models/tables:
Articles (id, title, content)
Categories(id, name, parent_id),
AriclesHasCategories(articlesId, categories Id)
I did all the relationships, and it work good when I do a simple findFirst, or find.
but it doesn't work when I for example Articles::find('category.name = 'Movies')
but I don't know how I can do to filter my articles results with e.g(WHERE categoryName = 'Programming')
Should I only use PHQL for that so I do a normal SQL query, I mean the ORM don't manage conditions like that ?