Querying a number field that is `null`

itsjxck

7 months ago

4

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

• 

  jesschow

  Payload Team

  6 months ago

  hi @itsjxck - 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,
            },
          }
        ]
      },

• 

  itsjxck

  6 months ago

  @jesschow 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