Supebase returns less items

Hi @Tbiyss :wave:

While I can understand your expectation here, enabling Always Output Data will cause n8n to return a single empty item if otherwise no item is returned, but it won’t respect the number of incoming items. That split items workaround you mentioned would be a workaround that helps with all nodes in n8n in these cases, not just Supabase :sweat_smile:

You could try this SQL query to do what you’re looking for, though:

You would unfortunately still need an extra node, as the Supabase node itself doesn’t have the option to run custom SQL queries.

1 Like