I hope someone may have solved this issue before. It involves rails3, kaminari and pg_search.
I've got pg_search working, but now the search is returned and the default order is not maintained. I don't mind having the subset returned in any order. But I want to maintain the subset of records returned by the search query and still be able to click on the column headers to sort the new data subset.
Now, when I select any of the column headers after a search, I get all of the db records displayed. If I change the search box to contain no text, I'd like all records should be displayed.
Is there a sequence of method calls that I can setup so that the subset of data is maintained while the column headers are still sortable?
I am now using this call sequence in my controller:
... def index @tips = Tip.text_search(params[:query]).order(sort_column + ' ' + sort_direction).page(params[:page]) end ...
Can anyone suggest a better approach?
Thanks,
Capt. Downer
