SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'active' in where clause is ambiguous

[dhruva81]

Hi
I am getting following exception on filtering.

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'active' in where clause is ambiguous 

select count(*) as aggregate from `chapters` left join `subjects` on `chapters`.`subject_id` = `subjects`.`id` where `active` = 1 and `chapters`.`deleted_at` is null

if I comment following column, then filter works perfectly

 Column::make('Subject', 'subject.name')
                ->sortable()
                ->searchable(),

[dhruva81]

Nevermind, I have figured out this.

The issue is, here 'active' is ambiguous because in join query both subjects and chapters table have same column 'active' .So where condition without table name is the cause of ambiguous.

So instead of using ->where('active', true) , use ->where('chapters.active', true)