The current Supabase Dart/Flutter query builder does not support cross-table filtering inside an .or() clause when using joins. For example, in a query like:
As supposed on sql query:
SELECT * FROM tableA AS a LEFT JOIN tableB AS b ON a.columnA1 = b.columnB1 WHERE a.columnA2 = <valueA> OR b.columnB2 = <valueB>;
The current Supabase Dart/Flutter query builder does not support cross-table filtering inside an .or() clause when using joins. For example, in a query like:
Query: 1
.or('<tableA>.<columnA>.<eq>.<valueA>, <tableB>.<columnB>.<eq>.<valueB>')Query: 2
.or(<columnA>.<eq>.<valueA>, <tableB>.<columnB>.<eq>.<valueB>',referencedTable: <tableA>)Throws an Error: code: PGRST100
As supposed on sql query:
SELECT * FROM tableA AS a LEFT JOIN tableB AS b ON a.columnA1 = b.columnB1 WHERE a.columnA2 = <valueA> OR b.columnB2 = <valueB>;