Ransack count sort order is wrong

[Gary_Riger]

I am using Ransack Gem and doing a count sort via counter cache. My attribute is an integer.

I am calling it like this:

<%= sort_link(@q, :people_count, "PEOPLE") %>

The sort output I am getting is:

[PEOPLE ASC]

1
2
0
0

[PEOPLE DESC]

0
0
2
1

I would like PEOPLE DESC to show:

2
1
0
0

Can anyone help out?

—UPDATE-----

After over an hour of searching I feel like I’m getting closer:

First I had to edit my view:

From

<%= mycontact.people.count %>

to

<%= mycontact.people_count %>

This changed all zeros to nil.

Now my sort output is:

[PEOPLE DESC]

nil
nil
2
1

Then I did some more digging and found the link to this issue on github which explains that you have to add NULLS LAST.

So I added the following code to peoples_controller.rb:

@q.result.except(:order).order("#{@q.sorts.first.attr_name} #{@q.sorts.first.dir} NULLS LAST")
I was excited at first because it worked but then after restarting my server am getting the following error:

undefined method `attr_name’ for nil:NilClass

[justin]

@Gary_Riger Please try to track down the line of code and the object that is nil in the Ransack library.

I just put together this tip to help you do that.

Wrappers on Debug Print Statements

I’m rarely using a debugger as I’ve found that it’s much faster to track down an issue with the right print statements. Basically I can type a lot faster than I can hit the next button and set breakpoints, and wait for the debugger to do its thing. This is how I set up the wrappers for the print statements. Putting a wrapper on your debug print statements accomplishes 2 things: It’s way easier to see your debug messages in the console log. It’s way easier to grep the code to find the debug me…

Once you do that, post what you find.