payload icon indicating copy to clipboard operation
payload copied to clipboard

Published 20 hours ago • verified publisher icon payloadcms

Can't Filter by Related Field? Postgres Bug?

Open JeremyEnglert opened this issue 9 months ago • 1 comments

Link to reproduction

No response

Describe the Bug

When we try to filter by a related field in the Payload dashboard, we never get any results back (or an error). It just sits on the loading screen as seen in the screenshot.

We're using Postgres (if that makes a difference). Is this a known bug or do I not have the collection(s) setup right?

ezgif-1-55d6346bda

To Reproduce

  • Setup a related field between two collections
  • Go to a collection screen and open the filters
  • Create a filter trying to filter on a related field

Payload Version

2.16.1

Adapters and Plugins

db-postgres

JeremyEnglert avatar May 15 '24 23:05 JeremyEnglert

I switched to MongoDB and I'm now able to filter as expected - so I believe this is related to Postgres.

JeremyEnglert avatar May 16 '24 02:05 JeremyEnglert

This has been fixed in the latest beta!

paulpopus avatar Jul 31 '24 22:07 paulpopus

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

github-actions[bot] avatar Sep 06 '24 22:09 github-actions[bot]