You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 text was updated successfully, but these errors were encountered:
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>;
The text was updated successfully, but these errors were encountered: