- foreign key로 검색할때 null되는거 걸르는 법
let query = supabase
.from("program")
.select("*, instructor_id(name)", { count: "exact" })
.order("created_at", { ascending: false })
.range((page - 1) * pageSize, page * pageSize - 1)
.not('instructor_id', 'is', null);
if (search) {
if (selectedFilter === "instructor") {
query = query.ilike('instructor_id.name', `%${search}%`)
} else {
query = query.or(`${selectedFilter}.ilike.%${search}%`);
}
}