Same data appears

[dondycles]

Hours passed and I am still stuck.

I just can't get the sorted data based on the sorting parameters I created and passed through the body. But, everytime I change the sorting, same data appears.

It was working with server actions but I am just trying Hono.

I am definitely wrong with what I am doing here so I seeking for a help.

client component:

const listPageState = useListPageState(); //zustand

const { data: moneysData, isLoading: moneysLoading } = useQuery({
    queryFn: async () => {
      const res = await fetch("/api/getmoneys", {
        method: "POST",
        headers: {
          "Content-Type": "application/json",
        },
        body: JSON.stringify({
          sortBy: listPageState.sort.by,
          asc: listPageState.sort.asc,
        }),
      });
      const moneys: Money[] = await res.json();
      return moneys;
    },
    refetchOnWindowFocus: false,
    queryKey: ["moneys", listPageState.sort.asc, listPageState.sort.by],
    enabled: mounted && !!user,
  });

hono api route:

app.post("/getmoneys", async (c) => {
  const supabase = createClient();
  const json = await c.req.json();

  const sortBy: "amount" | "created_at" | "color" = json.sortBy;
  const asc: boolean = json.asc;

  const { data, error } = await supabase
    .from("moneys")
    .select()
    .order(sortBy, { ascending: asc });

  if (error) return c.json({ error: error }, 400);
  return c.json(data, 200);
});

[dondycles]

Nevermind, I just fixed it by changing this:
const asc: boolean = json.asc;
to this:
const asc: boolean = Boolean(json.asc === "true");