Scheduled Post jobs not showing in Upcoming Events

Describe the Bug

Similar to this past issue. I'm not seeing scheduled posts in the "upcoming events" drawer after scheduling. This affects me using the d1 adapter, but also is reproducible using the sqlite website template using integer IDs.

http://localhost:3001/api/payload-jobs?sort=waitUntil&where%5Band%5D%5B0%5D%5BtaskSlug%5D%5Bequals%5D=schedulePublish&where%5Band%5D%5B1%5D%5BwaitUntil%5D%5Bgreater_than%5D=2026-01-07T19%3A25%3A46.351Z&where%5Band%5D%5B2%5D%5Binput.doc.value%5D%5Bequals%5D=3&where%5Band%5D%5B3%5D%5Binput.doc.relationTo%5D%5Bequals%5D=posts

The query to /payload-jobs with the param where[and][2][input.doc.value][equals]=3 does not return any results.

From the Payload Job collection UI I can see the value is set to string "3".

Manually changing the value to "abc" in the job, the endpoint returns the job in the response

.

http://localhost:3001/api/payload-jobs?sort=waitUntil&where%5Band%5D%5B0%5D%5BtaskSlug%5D%5Bequals%5D=schedulePublish&where%5Band%5D%5B1%5D%5BwaitUntil%5D%5Bgreater_than%5D=2026-01-07T19%3A25%3A46.351Z&where%5Band%5D%5B2%5D%5Binput.doc.value%5D%5Bequals%5D=abc&where%5Band%5D%5B3%5D%5Binput.doc.relationTo%5D%5Bequals%5D=posts

Link to the code that reproduces this issue

https://github.com/david-on-github/payload-bug

Reproduction Steps

Using the payload website template and selecting the sqlite db.

• pnpx create-payload-app@latest -t website
• Seed the db
• Schedule a post

It will not appear in upcoming events.

Which area(s) are affected?

area: ui

Environment Info

Binaries:
  Node: 22.18.0
  npm: 10.9.3
  Yarn: 1.22.19
  pnpm: 10.25.0
Relevant Packages:
  payload: 3.70.0
  next: 15.4.10
  @payloadcms/db-sqlite: 3.70.0
  @payloadcms/drizzle: 3.70.0
  @payloadcms/graphql: 3.70.0
  @payloadcms/live-preview: 3.70.0
  @payloadcms/live-preview-react: 3.70.0
  @payloadcms/next/utilities: 3.70.0
  @payloadcms/plugin-form-builder: 3.70.0
  @payloadcms/plugin-nested-docs: 3.70.0
  @payloadcms/plugin-redirects: 3.70.0
  @payloadcms/plugin-search: 3.70.0
  @payloadcms/plugin-seo: 3.70.0
  @payloadcms/richtext-lexical: 3.70.0
  @payloadcms/translations: 3.70.0
  @payloadcms/ui/shared: 3.70.0
  react: 19.2.1
  react-dom: 19.2.1
Operating System:
  Platform: darwin
  Arch: arm64
  Version: Darwin Kernel Version 24.5.0: Tue Apr 22 19:54:49 PDT 2025; root:xnu-11417.121.6~2/RELEASE_ARM64_T6000
  Available memory (MB): 16384
  Available CPU cores: 10