ajax-datatables-rails icon indicating copy to clipboard operation
ajax-datatables-rails copied to clipboard

Datatables paging when ActiveRecord query uses .group

Open toomanyjoes opened this issue 4 years ago • 0 comments

If the activerecord query that feeds the datatable uses group it totally breaks paging. I assume this is because .count is being called on the result set at some point when creating page elements and for a group by query .count returns a hash not a number.

My work around was to make another query in get_raw_records that uses a subquery on the model I'm querying to pluck the elements by their ids from the first query. Since this query is just a .where .count returns a number and it works. But it seems like this could be an easy fix if when using .count the code first checked for a hash before assuming it was returning a number.

toomanyjoes avatar Mar 07 '20 00:03 toomanyjoes