Is this a bug?

I’m getting some unexpected behaviour with a nested $or filter.

The first filter works fine and returns what I expect and matches from the first condition in the or statement, but once I add another condition to the second condition in the or statement, nothing is returned.

I should be able to put any non-matching condition there because its an or statement

filters: {
  team: teamId,
  $or: [
    {
      home_matches: {
        result: { $null:true },
        id: { $notNull: true }
      }
    },
    {
      away_matches: {
        result: { $null:true }
      }
    },
  ]
}

This topic has been created from a Discord post (1216724244390740068) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord

I think it is a bug, because it works as expected when going though the query engine