avram icon indicating copy to clipboard operation
avram copied to clipboard

Ordering fails for preload queries

Open snadon opened this issue 4 years ago • 0 comments

In this use case, tracks ordering does not work:

playlists = PlaylistQuery.new
      .preload_cover(
        StashQuery.new.preload_icon.preload_cover.preload_archive)
      .preload_tracks(
        StashQuery.new.preload_icon.preload_cover.preload_archive.ordering.asc_order)
      .preload_interviews(
        StashQuery.new.preload_icon.preload_cover.preload_archive.ordering.asc_order)
      .published(true)
      .ordering
      .asc_order
class Playlist < BaseModel
  table do
    column lang : Int32
    column title : String
    column ordering : Int32
    column description : String
    column published : Bool
    belongs_to cover : Stash?
    has_many playlists_tracks : PlaylistsTracks
    has_many tracks : Stash, through: [:playlists_tracks, :stash]
    has_many playlists_interviews : PlaylistsInterviews
    has_many interviews : Stash, through: [:playlists_interviews, :stash]
    belongs_to modified_by : User
  end
end
class Stash < BaseModel
  table do
    column lang : Int32
    column ordering : Int32
    column title : String
    column slug : String
    column author : String?
    belongs_to icon : Stash?
    belongs_to cover : Stash?
    has_many playlists_tracks : PlaylistsTracks
    has_many playlists_interviews : PlaylistsInterviews
    belongs_to modified_by : User
  end
end

snadon avatar Apr 22 '21 16:04 snadon