[DC-627] Work on link-table and leftJoin Created: 13/Apr/10 Updated: 13/Apr/10
|Reporter:||Thomas Tourlourat - Armetiz||Assignee:||Guilherme Blanco|
Windows Seven - WAMP 2.0i
Looking at the attachment to see the little schema.
The link-table items_children is here to create a many-to-many relationships between Items and Children.
So, after configure the YAML and generated Models.
The SQL Output of the query is :
All array are order by something, in this case it's a natural order which come from the items_children order into database.
Now, I want to apply a condition, or a filter on the items_children table.
Or something crazy :
But how can I do that with DQL ? Because I have no access to the Link-table.
Link-Table are use to create many-to-many, that could be OOP array. So we have to be allowed to add "index" to order the result. Also, we have to be allowed to add condition on this tables, like "datePromote" or simply "enabled".
The solution should be on the following DQL Query :
But the SQL Output is :
To conclude, it's a blocker problem. Because I can't use a standard DB schema.