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:
Startup payload:
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
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
equalsin combination with number values. This request for example is not working with theinput.doc.valuewhere:Without the
input.doc.valueit is returning the expected result.Representation in the database is the following. If i change the
valueto"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:
Startup payload:
Create a new entry in the
Bugcollection 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