Unable to order by computed field defined as method in model, only fields as in database columns are working.

[sameer1612]

trafficstars

Taking same city example:

How to proceed if I want to sort by "full_name"?

City model :

` class City < ApplicationRecord belongs_to :country

def full_name name + ' city' end end `

city_datatable.rb :

` def view_columns @view_columns ||= { check_box: { source: 'City.id', orderable: false, searchable: false }, name: { source: 'City.name' }, iata: { source: 'City.iata' }, country_name: { source: 'City.country_id', cond: filter_country_condition }, full_name: { source: 'City.full_name', searchable: false } } end

def data records.map do |record| { check_box: record.decorate.to_checkbox(selected: selected.include?(record.id)), name: record.name, iata: record.iata, country_name: record.country.try(:name), full_name: record.full_name } end end `

Haml file changes.

`

• t.head_for_check_box
• t.head_for :name, label: City.human_attribute_name('name')
• t.head_for :iata, label: City.human_attribute_name('iata')
• t.head_for :country_name, label: City.human_attribute_name('country_name')
• t.head_for :full_name, label: City.human_attribute_name('full_name') `

---

ERROR :

` Completed 500 Internal Server Error in 9ms (ActiveRecord: 1.0ms | Allocations: 2457)

ActiveRecord::StatementInvalid (SQLite3::SQLException: no such column: cities.full_name):

app/datatables/city_datatable.rb:15:in map' app/datatables/city_datatable.rb:15:in data' app/controllers/cities_controller.rb:15:in block (2 levels) in datatable' app/controllers/cities_controller.rb:14:in datatable' `