Hoping you can help with this, it’s starting to mess with my head
Let me tell you the desired outcome first …
Sort on a field that is in a linked table, Artist Name then by Release Title when viewing the albums in a category.
In the Categories table, artists are linked by ID
In the Category#Show, I have
@releases = Shelf.joins(:artists).find(@shelf.shelf_discogs_id).releases.order('release_title ASC').page params[:page]
The above code works to sort by the Release Title, however, I can’t find a way to make it sort by the Artist Name, which is part of the Artists table.
joins(:artists) does add the correct line in the console to link correctly (from what I can tell)
Any ideas how i can achieve what I’m looking to do?