Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot query relationship in blocks #9171

Closed
stofolus opened this issue Nov 13, 2024 · 4 comments · Fixed by #9115
Closed

Cannot query relationship in blocks #9171

stofolus opened this issue Nov 13, 2024 · 4 comments · Fixed by #9115

Comments

@stofolus
Copy link
Contributor

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

This comment has been minimized.

r1tsuu added a commit that referenced this issue Nov 14, 2024
@r1tsuu r1tsuu added the status: verified If an issue has been reproduced label Nov 14, 2024
@github-actions github-actions bot removed the status: needs-triage Possible bug which hasn't been reproduced yet label Nov 14, 2024
@r1tsuu
Copy link
Member

r1tsuu commented Nov 14, 2024

Hello @stofolus, thanks for the issue.
This PR #9115 will fix it, my test passes there (while doesn't on beta)

@r1tsuu r1tsuu closed this as completed Nov 14, 2024
@r1tsuu r1tsuu reopened this Nov 14, 2024
@github-actions github-actions bot added status: needs-triage Possible bug which hasn't been reproduced yet and removed status: verified If an issue has been reproduced labels Nov 14, 2024
@r1tsuu r1tsuu added the status: verified If an issue has been reproduced label Nov 14, 2024
@github-actions github-actions bot removed the status: needs-triage Possible bug which hasn't been reproduced yet label Nov 14, 2024
@github-actions github-actions bot removed the status: verified If an issue has been reproduced label Nov 15, 2024
Copy link
Contributor

🚀 This is included in version v3.0.0-beta.131

Copy link
Contributor

This issue has been automatically locked.
Please open a new issue if this issue persists with any additional detail.

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Nov 17, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants