Relationship column name not found in select list

[Bhagwan00]

columns: [
{ name: 'committee.name', orderable: false },
{ name: 'school'},
{ name: 'firstname'},
{ name: 'control', orderable: false, searchable: false},
{ name: 'message_flag', visible: false},
{ name: 'committee_id', visible: false},
]

[hirenkeraliya]

Provide more details.

[gauravmak]

I guess this is same as issue #32
Please check and update there.

[ghost]

@Bhagwan00 It's happen when you try to use the relationship column at first
But if you change the order it will work

columns: [
{ name: 'school'},
{ name: 'committee.name', orderable: false },
{ name: 'firstname'},
{ name: 'control', orderable: false, searchable: false},
{ name: 'message_flag', visible: false},
{ name: 'committee_id', visible: false},
]
** or something else

## I don't know why. But I face same problem

[gauravmak]

That means - Datatables sorts the records by the first column if not specified.

[agasigp]

@Bhagwan00 It's happen when you try to use the relationship column at first
But if you change the order it will work

columns: [
{ name: 'school'},
{ name: 'committee.name', orderable: false },
{ name: 'firstname'},
{ name: 'control', orderable: false, searchable: false},
{ name: 'message_flag', visible: false},
{ name: 'committee_id', visible: false},
]
** or something else

## I don't know why. But I face same problem

Thanks for the solution! I have same problem with you. Problem was solved by changing order of column like you said.