Sortable and Searchable in pivot column not working
I have a many-to-many relationship between Company and Person.
The pivot table and model (CompanyPerson) has an office column that refers to another model.
The data displays correctly in the table when accessing "pivot.office.name", but the ->searchable() and ->sortable() methods don’t work.
What is the best way to fix this?
This is the error I get when trying to search for an office name:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pivot' in 'WHERE'
select
count(*) as aggregate
from
inner join
where
and (
json_unquote(json_extract(
)
and
And this is the table:
Everything works, except making the pivot column searchable and sortable.
The pivot table and model (CompanyPerson) has an office column that refers to another model.
The data displays correctly in the table when accessing "pivot.office.name", but the ->searchable() and ->sortable() methods don’t work.
What is the best way to fix this?
This is the error I get when trying to search for an office name:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pivot' in 'WHERE'
select
count(*) as aggregate
from
companiesinner join
company_personcompaniesidcompany_personcompany_idwhere
company_personperson_idand (
json_unquote(json_extract(
pivot)
and
companiesdeleted_atAnd this is the table:
Everything works, except making the pivot column searchable and sortable.
