Chained Select Fields

etmartinkazoo

4 months ago

1 1

• Selected Answer
  

  DanRibbens

  Payload Team

  4 months ago

  This is what the filterOptions property is for on the relationship field.
  You will return a query on your projects field's filterOptions to only get the projects equal to the organization ID that is selected from your data or siblingData.

  https://payloadcms.com/docs/fields/relationship#filtering-relationship-options

  7 replies
• 

  etmartinkazoo

  4 months ago

  Okay, that is helpful. I've been in that part of the docs and have the following:

  {
        name: 'projects',
        type: 'relationship',
        relationTo: 'projects',
        filterOptions: ({ siblingData }) => {
          return {
            'id': { equal: siblingData.organization }
          }
        },
  },
  

  Hope you are staying warm in the Michigan snowstorm!

• 

  etmartinkazoo

  4 months ago

  Okay, I have it working now with the following:

  const projectsField = {
    name: 'project',
    admin: {
      position: 'sidebar'
    },
    type: 'relationship',
    relationTo: 'projects',
    filterOptions: ({ siblingData }) => {
      return {
        'organization': { equals: siblingData.organization }
      }
    },
  };
  

  The only issue is that I have to save the record first and it only filters after clicking save.

• 

  etmartinkazoo

  4 months ago

  I'm also wondering if the newly announced use-context-selector (https://payloadcms.com/blog/launch-week-day-4) might be of help in this scenario?

• 

  DanRibbens

  Payload Team

  4 months ago

  Thanks for the update. That issue is something we need to address. Would you want to create a new issue for it?

• 

  etmartinkazoo

  4 months ago

  @DanRibbens - Sure thing, I'll create an issue now.

• 

  DanRibbens

  Payload Team

  4 months ago

  Thanks! Have a great weekend and stay warm!

• 

  etmartinkazoo

  4 months ago

  I had to help a friend get their truck with snow plow this evening and it was terrible out; less than 10 feet of visibility on the interstate. Definitely pretty from indoors but not safe otherwise.