Describe the Bug
Before the change where relationship keys became ObjectIds it was possible to query like this (Website template, seeded contact page) when the layout has a form block with a specific id.
const pages = await payload.find({
collection: 'pages',
where: {
'layout.form': { equals: '6734cc2aa1b5d8b785404546' },
},
})
This will no work and it seems to be because it's an object id now.
If would be great if this could work again or at least if there was a way to tell payload that this is an ObjectId
Link to the code that reproduces this issue
Website template. Seed the database
Reproduction Steps
- Use create-payload-app with the website template.
- Seed the DB
- Grab the ID of the form on the contact page
- Write a query somewhere like this
const pages = await payload.find({
collection: 'pages',
where: {
'layout.form': { equals: <insertId> },
},
})
Get an empty result :'(
Now you can either trust me or change the value in the database from an ObjectId to a string with the same value and you'll se it working.
Which area(s) are affected? (Select all that apply)
db-mongodb
Environment Info
Binaries:
Node: 20.17.0
npm: 10.8.2
Yarn: N/A
pnpm: 9.0.2
Relevant Packages:
payload: 3.0.0-beta.129
next: 15.0.0
@payloadcms/db-mongodb: 3.0.0-beta.129
@payloadcms/email-nodemailer: 3.0.0-beta.129
@payloadcms/graphql: 3.0.0-beta.129
@payloadcms/live-preview: 3.0.0-beta.129
@payloadcms/live-preview-react: 3.0.0-beta.129
@payloadcms/next/utilities: 3.0.0-beta.129
@payloadcms/payload-cloud: 3.0.0-beta.129
@payloadcms/plugin-form-builder: 3.0.0-beta.129
@payloadcms/plugin-nested-docs: 3.0.0-beta.129
@payloadcms/plugin-redirects: 3.0.0-beta.129
@payloadcms/plugin-search: 3.0.0-beta.129
@payloadcms/plugin-seo: 3.0.0-beta.129
@payloadcms/richtext-lexical: 3.0.0-beta.129
@payloadcms/translations: 3.0.0-beta.129
@payloadcms/ui/shared: 3.0.0-beta.129
react: 19.0.0-rc-65a56d0e-20241020
react-dom: 19.0.0-rc-65a56d0e-20241020
Operating System:
Platform: linux
Arch: x64
Version: #1 SMP Tue Nov 5 00:21:55 UTC 2024
Available memory (MB): 15970
Available CPU cores: 12
Describe the Bug
Before the change where relationship keys became ObjectIds it was possible to query like this (Website template, seeded contact page) when the layout has a form block with a specific id.
This will no work and it seems to be because it's an object id now.
If would be great if this could work again or at least if there was a way to tell payload that this is an ObjectId
Link to the code that reproduces this issue
Website template. Seed the database
Reproduction Steps
Get an empty result :'(
Now you can either trust me or change the value in the database from an ObjectId to a string with the same value and you'll se it working.
Which area(s) are affected? (Select all that apply)
db-mongodb
Environment Info