Custom search about effective_datatables HOT 6 CLOSED

I would expect the collection there to be an ActiveRecord::Relation there. Can I see the whole datatable? Could be something weird going on.

from effective_datatables.

Here: https://gist.github.com/Nerian/d1391d2773acfbffb3b0b131fc986e41

from effective_datatables.

I think datatables is treating member_id as an array-based column, because Charge.new doesn't respond to member_id.

Try adding sql_column to the col line:

col :member_id, sql_column: 'invoices.member_id'

You might not even need a custom search method anymore!

from effective_datatables.

Nice :)

That fixes it. Should we consider this a bug or should I be adding this parameter in other places too?

from effective_datatables.

I don't consider this a bug.

Datatables is pretty smart about a single model (with it's belongs_to and has_many) but when you're doing crazy joins and such it needs a little bit of help :)

I will add to the documentation about this!

Thanks as always @Nerian

from effective_datatables.

Sounds good :) Thanks for your work. The new version is working quite well :)

from effective_datatables.