Hello, every one. I need some help with ScalikeJDBC, thats why this question for its users.
my project have next tables: Posts, Users, Votes. Post one-to-many Votes, Post many-to-one users. I want to get All posts with comments and user and order by comments count. First problem was uncorrect limit, but I fixed this by sub-queries. But how can I sort posts by count queries ?
I know how to do it in SQL. How can i order by count(v.voteId) in DSL ? .orderBy(x(count(v.voteId))) not working