Scheduled Post jobs not showing in Upcoming Events

[david-on-github]

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

[paulpopus]

You need to query using a string for the ID because the input in the job collection there is a json field and we standardise the IDs for storing into JSON consistently.

You can verify this by querying for "3" instead of 3 in your initial query.

Do let me know if it still doesn't work though!

[david-on-github]

@paulpopus

Sorry, to clarify my issue is in the payload UI. Specifically the ScheduleDrawer component. Not a query I am trying to run.

The network query I showed above comes from that component. Here:

payload/packages/ui/src/elements/PublishButton/ScheduleDrawer/index.tsx

Lines 137 to 146 in fa6b503

	const { docs } = await requests
	.post(formatAdminURL({ apiRoute: api, path: `/payload-jobs` }), {
	body: qs.stringify(query),
	headers: {
	'Accept-Language': i18n.language,
	'Content-Type': 'application/x-www-form-urlencoded',
	'X-Payload-HTTP-Method-Override': 'GET',
	},
	})
	.then((res) => res.json())

Enabling the payload jobs, I can see its there.

__

Also, I tried adding quotes. But I think it's still getting coerced back into a number somewhere.