How to filter out relational select field for many-to-many?

[karmic salmon]

I have projects collection, that references ProjectRoles collection

but I want to make only options that related to the same project appear

[keen tide]

New Community-Help Thread Created!

Help is on the way! To mark it as solved, use the /solve command. In the meantime, here are some existing threads that may help you:

Documentation:

• Database - Selecting a Database - Non-Relational Databases
• Select Field - Config Options
• Join Field - Using the Join field to have full control of your database schema - Specifying additional fields on relationships
• Production Deployment - Database - CosmosDB
• Relationship Field - How the data is saved - Has Many - Polymorphic

[karmic salmon]

here is my code

as you can see there is only roles for Project 2

but these options appear in Project 1

how do I filter them out?

[kindred lava]

You wanna use the filterOptions to limit things in the UI https://payloadcms.com/docs/fields/relationship#filtering-relationship-options

[karmic salmon]

thanks a lot!