CODEWITHSUNDEEP
ruby-on-railsransack
Joseph Le Brech
Joseph Le Brech

Reputation: 6653

Ransack sort_link for foreign attribute

I have a belongs_to relationship and I'm showing the name of the user is this instance.

But I would like to sort by user name.

<th><%= sort_link @q, :user_id %></th>

How would I go about sorting by the user name rather that user.id?

Upvotes: 0

Views: 3455

Answers (1)

jaeheung
jaeheung

Reputation: 1208

Your question lacks some necessary details, so I am guessing many things.

First did you try:

<th><%= sort_link @q, :user_name %></th>

Or if your user name column name is username:

<th><%= sort_link @q, :user_username %></th>

Here 'user' before '_' is the name of user table(model).

You may need to edit the controller to change

@q = YourModel.search(params[:q])

into

@q = YourModel.joins(:users).search(params[:q])

Upvotes: 9

Related Questions