beam icon indicating copy to clipboard operation
beam copied to clipboard

Combine orderBy_ with join_

Open shlevy opened this issue 4 years ago • 1 comments

If I have a join_ where I compare some row's value to the primaryKey of some previous result in the same query, I can no longer orderBy_ directly on that join_ (due to a mismatch between QBaseScope and QNested QBaseScope). Instead I have to move the orderBy_ to the whole select. Is there a reason the result of the subquery returning the foreign key can't be more polymorphic?

shlevy avatar Jun 01 '21 13:06 shlevy

What exactly do you propose making more polymorphic?

An example/snippet with the desired SQL would help.

kmicklas avatar Jul 12 '21 00:07 kmicklas