Admin Panel: exists filter does not work for number fields

[sorra]

Link to reproduction

No response

Describe the Bug

There is a number field named numeric:

• if its value is undefined, either exists: true or exists: false returns it.

• if its value is a number, either exists: true or exists: false not returns it.

Note: the related MongoDB queries seemed correct.

To Reproduce

1. Create a project using npx create-payload-app@latest, select blank project and mongodb adapter
2. Add a collection using the following code snippet:

import { CollectionConfig } from 'payload/types'

const Buyers: CollectionConfig = {
  slug: 'buyers',
  admin: {
    useAsTitle: 'id',
  },
  fields: [
    {
        name: 'id',
        type: 'text',
        required: true,
        index: true,
        unique: true,
    },
    {
        name: 'numeric',
        type: 'number',
        required: false,
    }
  ],
}

export default Buyers

3. Create a buyer in admin panel and filter by exists on the number field

Payload Version

2.28

Adapters and Plugins

db-mongodb

[github-actions]

This issue has been automatically locked.
Please open a new issue if this issue persists with any additional detail.

[github-actions]

🚀 This is included in version v2.30.1