Querying a number field that is `null`

itsjxck2 years ago

2

{
  or: [
    {
      numberField: {
        exists: false,
      },
    },
    {
      numberField: {
        equals: null,
      },
    },
  ],
}

• 

  jessrynkar2 years ago

  hi

  @93699784942034944

  - I replicated your query and it worked correctly for me. Exists>false returned the same docs as equals>null.

  
  
  

  To get the docs that have

  numberField: null

  and not the ones where it is undefined, I used:

  
  

  where: {
        and: [
          {
            numberField: {
              equals: null,
            },
          },
          {
            numberField: {
              exists: true,
            },
          }
        ]
      },

• 

  itsjxck2 years ago

  @854377910689202256

  thanks for that; I can confirm it does indeed work when doing this in payload, but in a REST query, it does not work

  
  
  

  I assume this is because

  null

  is not a valid query parameter value

  
  
  

  This behaviour seems strange though, I would expect that a field that has it's values removed, would have the same

  undefined

  value as if the field had never had the value set in the first place