select filter with belongsToMany
im get error when selectfilter in table belongsToManyRelation. this code worked in filament version2!!
SQLSTATE[42883]: Undefined function: 7 ERROR: could not identify an equality operator for type json LINE 1: select distinct "gen_constants".* from "gen_constants" left ... ^
SELECT
DISTINCT "gen_constants".*
FROM
"gen_constants"
LEFT JOIN "inf_learn_box_sections" ON "gen_constants"."id" = "inf_learn_box_sections"."section_id"
WHERE
"parent_id" = -1000
ORDER BY
"gen_constants"."name" ASC
--------------
this filter::
SelectFilter::make('sections')
->label('categoryFilter')
->relationship('sections', 'name' , function (Builder $query){
$query->where('parent_id', Constants::MainCategory);
})
SQLSTATE[42883]: Undefined function: 7 ERROR: could not identify an equality operator for type json LINE 1: select distinct "gen_constants".* from "gen_constants" left ... ^
SELECT
DISTINCT "gen_constants".*
FROM
"gen_constants"
LEFT JOIN "inf_learn_box_sections" ON "gen_constants"."id" = "inf_learn_box_sections"."section_id"
WHERE
"parent_id" = -1000
ORDER BY
"gen_constants"."name" ASC
--------------
this filter::
SelectFilter::make('sections')
->label('categoryFilter')
->relationship('sections', 'name' , function (Builder $query){
$query->where('parent_id', Constants::MainCategory);
})
