Getting right a query with OR and nested AND

[stefanorumi7]

Hey peepz, I am using brick + supabase and I am trying to get a query to work and I can't:

I have a query of the type

SELECT *
FROM entityA
WHERE columnA != 'valueA' 
   OR (columnA IS NULL AND columnB = false)

I tried the following

WherePhrase _getCondition() {
    return WherePhrase([
      const Or('columnA').isNot('valueA'),
      const WherePhrase([
        Where.exact('columnA', null),
        Where.exact('columnB', false),
      ]),
    ]);
  }

And some similar variations.

Anyone has suggestions?

[TeoVogel]

A very late reply, but have you tried making the second WherePhrase required: true? What is the output of the code that you are showing?

[stefanorumi7]

With isRequired: true I get the error

I/flutter (21502): OfflineFirstRepository: WARNING: #hydrate supabase failure: PostgrestException(message: "failed to parse logic tree ((or.(columnA.neq.valueA, columnA.eq.null, columnB.eq.false), user_id.eq.UUID))" (line 1, column 6), code: PGRST100, details: unexpected "." expecting "(", hint: null) 

With isRequired: false I get the error

I/flutter (21502): OfflineFirstRepository: WARNING: #hydrate supabase failure: PostgrestException(message: "failed to parse logic tree ((or.(columnA.neq.valueA, columnA.eq.null, columnB.eq.false)))" (line 1, column 6), code: PGRST100, details: unexpected "." expecting "(", hint: null) 

They look the same (ignore the user_id part please).