When i am trying to sort with the column categories, it is giving errors.
n ActiveRecord::StatementInvalid occurred in contacts#index:
PG::UndefinedColumn: ERROR: column contacts.contact_categories does not exist
LINE 1: ...LL AND "contacts"."organization_id" = $1 ORDER BY contacts.c...
^
: SELECT "contacts".* FROM "contacts" INNER JOIN "contact_contact_categories" ON "contact_contact_categories"."contact_id" = "contacts"."id" WHERE "contacts"."deleted_at" IS NULL AND "contacts"."organization_id" = $1 ORDER BY contacts.contact_categories ASC LIMIT $2 OFFSET $3
Hi, I am facing in writing the joins or includes complex queries for this gem.
Models:- class Contact < ApplicationRecord has_many :contact_contact_categories has_many :contact_categories, through: :contact_contact_categories end
class ContactCategory < ApplicationRecord has_many :contact_contact_categories, dependent: :destroy has_many :contacts, through: :contact_contact_categories end
This is my contact_datatable.rb class ContactDatatable < AjaxDatatablesRails::ActiveRecord
extend Forwardable
def_delegators :@view, :link_to, :edit_contact_path
def initialize(params, opts = {}) @view = opts[:view_context] super end
def view_columns @view_columns ||= { name: { source: "Contact.decorate.name" }, organization_name: { source: "Contact.decorate.organization_name" }, contact_categories: { source: "Contact.decorate.contact_categories" }, phone: { source: "Contact.decorate.phone" }, email: { source: "Contact.decorate.email" }, dt_actions: { source: "Contact.decorate.dt_actions", searchable: false, orderable: false }, } end
def data records.map do |record| decorated_record = record.decorate { name: decorated_record.name, organization_name: decorated_record.organization_name, contact_categories: decorated_record.contact_categories, phone: decorated_record.phone, email: decorated_record.email, dt_actions: decorated_record.dt_actions, DT_RowId: record.id, } end end
def get_raw_records params[:contacts].joins(:contact_contact_categories) end
end
contact_decorator.rb
class ContactDecorator < Draper::Decorator include Draper::LazyHelpers delegate_all
def dt_actions "
end
def name link_to(object.name, edit_contact_path(object), class: 'custom-href', data: { turbolinks: false }) end
def email link_to(object.email.presence || '', edit_contact_path(object), class: 'custom-href', data: { turbolinks: false }) end
def organization_name link_to(object.organization_name.presence || '', edit_contact_path(object), class: 'custom-href', data: { turbolinks: false }) end
def phone link_to(object.phone_number_1.presence || '', edit_contact_path(object), class: 'custom-href', data: { turbolinks: false }) end
def contact_categories link_to(object.contact_categories.pluck(:name).join(', ') || '', edit_contact_path(object), class: 'custom-href', data: { turbolinks: false }) end
end This is the view
<%= render partial: "/shared/confirmation_popup", locals: { record_type: 'Contact' } %>
When i am trying to sort with the column categories, it is giving errors.
n ActiveRecord::StatementInvalid occurred in contacts#index:
PG::UndefinedColumn: ERROR: column contacts.contact_categories does not exist LINE 1: ...LL AND "contacts"."organization_id" = $1 ORDER BY contacts.c... ^ : SELECT "contacts".* FROM "contacts" INNER JOIN "contact_contact_categories" ON "contact_contact_categories"."contact_id" = "contacts"."id" WHERE "contacts"."deleted_at" IS NULL AND "contacts"."organization_id" = $1 ORDER BY contacts.contact_categories ASC LIMIT $2 OFFSET $3
How will i fix it?