Scheduled publish/unpublish not showing upcoming events

[MichaelAlt]

Describe the Bug

#10203 Upcoming publish/unpublish events are not visible in the overview.

This seams to be an issue with "number" vaules in (postgres only?).

It seams to be the equals in combination with number values. This request for example is not working with the input.doc.value where:

http://localhost:3000/api/payload-jobs?where[and][0][taskSlug][equals]=schedulePublish&where[and][1][input.doc.relationTo][equals]=bugs&where[and][2][input.doc.value][equals]=2

Without the input.doc.value it is returning the expected result.

http://localhost:3000/api/payload-jobs?where[and][0][taskSlug][equals]=schedulePublish&where[and][1][input.doc.relationTo][equals]=bugs

Representation in the database is the following. If i change the value to "1" instead of it beeing a number it is working again.

Link to the code that reproduces this issue

https://github.com/MichaelAlt/payload-schedule-bug

Reproduction Steps

First startup the docker environment with postgres:

docker compose up -d

Startup payload:

pnpm i && pnpm dev

Create a new entry in the Bug collection and create and publish schedule. It will not appear in the list of upcoming events.

Which area(s) are affected? (Select all that apply)

db-postgres, area: core

Environment Info

Binaries:
  Node: 20.9.0
  npm: 10.2.4
  Yarn: N/A
  pnpm: 9.15.2
Relevant Packages:
  payload: 3.12.0
  next: 15.1.0
  @payloadcms/db-postgres: 3.12.0
  @payloadcms/email-nodemailer: 3.12.0
  @payloadcms/graphql: 3.12.0
  @payloadcms/next/utilities: 3.12.0
  @payloadcms/payload-cloud: 3.12.0
  @payloadcms/richtext-lexical: 3.12.0
  @payloadcms/translations: 3.12.0
  @payloadcms/ui/shared: 3.12.0
  react: 19.0.0
  react-dom: 19.0.0
Operating System:
  Platform: darwin
  Arch: arm64
  Version: Darwin Kernel Version 24.2.0: Fri Dec  6 19:02:41 PST 2024; root:xnu-11215.61.5~2/RELEASE_ARM64_T6030
  Available memory (MB): 36864
  Available CPU cores: 11