List block conditional filter returns "something went wrong" with Supabase SQL query datasource

Ask the community
1

On a product detail page, I have two blocks:

  1. Item details block sourcing from a custom SQL query (SELECT * FROM public_products) — this works correctly and displays the right product when navigating from the products list page.
  2. List block sourcing from a custom SQL query (SELECT * FROM public_part_assignments ORDER BY group_sort_order) with a conditional filter set to id is current record: id — this consistently returns “something went wrong. Please refresh the page and try again.”

The id column is in both views and values match in Supabase. RLS is disabled on all tables. A new list block will load data without a filter but fails once the filter is added.

2

My workaround was born from finding this post: Custom HTML block not receiving data from get-record-item-details event on Item Details page .

I originally wanted a more OOTB solution but the custom block works absolutely perfect.

3

Sorry for bumping an old thread, but I’m curious if anyone has found a better solution since this was last discussed. Has Softr introduced any new features or fixes that address this issue? I’d love to hear how everyone is managing conditional filters with custom SQL queries now. Let’s keep the discussion going to help anyone facing similar hurdles!