rpc_operators.dart

 final productResults = await _odooClient.callKw({
        'model': 'product.template', // Selecting from 'product.template' model
        'method': 'search_read',
        'args': [],
        'kwargs': {
          'domain': [
            ['sale_ok', '=', true], // WHERE sale_ok = true
            ['list_price', '>', 100.0], // AND list_price > 100.0
            '|', // OR (applies to the next two conditions)
            ['type', '=', 'product'], // type = 'product'
            ['type', '=', 'consu'], // OR type = 'consu'
            ['!', ['active', '=', false]], // NOT active = false (i.e., active = true)
          ],
          'fields':[
            //fields here
          ],
         OFFSET 0 (first page)
        },
      });