SupabaseS
Supabase•2y ago
Lord Albert

Add a boolean field into the `select` if another column is present

I have this code in Supabase, my pages table has a column called outputs which is a nullable JSONB column.

It is a fairly large column and I do not want to load it for every page in my request, rather I want to have a simple boolean to know whether the field is empty or not. How do I achieve this?
    const { data: pages } = await data.supabase.from("pages")
        .select(`
            id,
            url,
            parent_page,
            is_collection
        `)
        .eq("brand", brand)
Was this page helpful?