[Access] Paths cannot be queried

[KomlevDm]

Link to reproduction

https://github.com/KomlevDm/payload/tree/access-query-issue

To Reproduce

1. go to test/_community/collections/Media/index.ts
2. add query to MediaCollection.access.read (test/_community/collections/Media/prod.ts and test/_community/collections/Media/published.ts)
3. start dev server
4. open http://localhost:3000/admin/collections/media
5. page is broken
6. get error The following paths cannot be queried: _prod, _prod, _status, _status

link in test repo

Describe the Bug

Our team has migrated from 1.6.32 to 1.7.4 version. And now we get a global problem (400 Bad Request) in admin panel: The following paths cannot be queried. We think it's related to feat: refactors buildQuery to rely on fields instead of mongoose (d187b809d) in 1.7.0 release. Something very similar was here, but unfortunately it doesn’t fix current issue.

Payload Version

1.7.4

[jmikrut]

Hey @KomlevDm — I can shine some light here for you.

Basically, we have implemented query validation, among other things. Your reproduction repo attempts to query on fields that do not exist in your schema.

I assume you are injecting fields with Mongoose directly or similar, but those fields are not reflected in your Payload collection config(s).

To fix this, you need to make sure that you have fields that reflect anything that you query on. If you don't want them to show up in the admin UI, but you want them to be available to query on, you can set these fields to admin.disabled to hide them entirely from admin UI, but then your queries will once again work.

Regarding the _status field, same thing there - your Media collection does not have versions.drafts: true, so you have no _status field, and thus can't query on that field.

I will convert this to a discussion because everything is functioning as-intended, but I am happy to continue helping!