Hello, I currently have two tables.
table b (
So table A holds an id from table B. During the listing of tuples in
table A, it lists table A’s attributes. In place of the table B id, I
check the id, and instead display the name corresponding to that id. Now
I want to be able to sort the listing of tuples in table A by the names
of table B. Here is some code to hopefully help you understand more
clearly what I’m trying to do.
sort = case @params[:sort] when "last inserted" then "id DESC" when "name" then "table_b.name" # <---- does not work end @table_a_pages, @table_as = paginate :table_a, :order => sort,
:per_page => 10
At the noted line, I am unable to use table_b.name to sort the list. Any
suggestions on how to solve this? Thanks!