Join on array field element property

[decanTyme]

I have the following array field:

// `profiles` collection
{
  type: 'array',
  name: 'subscriptions',
  required: true,
  fields: [
    {
      type: 'relationship',
      name: 'item',
      relationTo: ['movies', 'shows'],
      required: true,
    },
  ],
}

Then in the movies for example I tried to join with:

{
  type: 'join',
  name: 'basic',
  collection: 'profiles',
  on: 'subscriptions.item',
}

But I get an error:

ERROR: There was an error building form state
    err: {
      "type": "QueryError",
      "message": "The following path cannot be queried: subscriptions.item"

It's not an InvalidFieldJoin error so it does seem to find the item field and validate that it's a relationship. Is this the intended behaviour? I got the idea from this issue too so I assumed it would just work.

[r1tsuu]

Do you have a where query somewhere that queries subscriptions.item? We indeed do not support querying on join fields right now, see - #9683

[decanTyme]

I am using the filterOptions in the item field, does that count as querying on join fields? Otherwise, I don't think I'm using any (sorry, still new to payload)