Open alihammad-gist opened 9 years ago
Don't merge this, This alias is being used in Order By clause too, which doesn't work.
Select r as rank, COUNT(m) as members_count FROM Staff\Entity\Rank r LEFT JOIN r.members as m GROUP BY r.id ORDER BY rank.id asc
Also added the ability to reference nested "aliased" results generated by queries like below. I have not changed the behavior which was present already. Sorry for un-necessary conflicts because of my auto formatting tool .
Sample result set.
As you can see the immediate child of top-level array is another array not the entity itself. Below is a sample DataTable for queries like this.