error related to Field
i get the below message when trying to filter by a joined table
error message:
{
"code": "PGRST100",
"details": "unexpected "c" expecting "not" or operator (eq, gt, ...)",
"hint": null,
"message": ""failed to parse logic tree ((all_classes.eq.true,event_classes.class_id.eq.8))" (line 1, column 38)"
}
my code:
const { data, isLoading } = useList<{
id: number;
meal_id: number;
meal_category: string;
}>({
resource: "events",
filters: [
{
operator: "or",
value: [
{ field: "all_classes", operator: "eq", value: true },
{ field: "event_classes.class_id", operator: "eq", value: 8 },
],
},
],
pagination: { current: 1, pageSize: 100 },
meta: {
select: "id,meal_id,meal_category,event_classes!inner(class_id)",
},
});
error message:
{
"code": "PGRST100",
"details": "unexpected "c" expecting "not" or operator (eq, gt, ...)",
"hint": null,
"message": ""failed to parse logic tree ((all_classes.eq.true,event_classes.class_id.eq.8))" (line 1, column 38)"
}
my code:
const { data, isLoading } = useList<{
id: number;
meal_id: number;
meal_category: string;
}>({
resource: "events",
filters: [
{
operator: "or",
value: [
{ field: "all_classes", operator: "eq", value: true },
{ field: "event_classes.class_id", operator: "eq", value: 8 },
],
},
],
pagination: { current: 1, pageSize: 100 },
meta: {
select: "id,meal_id,meal_category,event_classes!inner(class_id)",
},
});
