Can't filter by field in production

System Information
  • Strapi Version: 4.1.8
  • Operating System: Linux
  • Database: Postgres
  • Node Version: 16.4.2
  • Yarn Version: 3.2.1

I have a strange issue whereby in our staging environment we can filter by a “band” field, which is a relation to the “band” collection type.

However, in our production environment (same codebase, different db), we are unable to filter by the “band” field. All other fields are in the filter dropdown, and I can’t see anywhere that configures which fields are filterable.

Is this a bug or am I just not looking in the right place to allow filtering on the band field?

Thanks

Still don’t have a solution to this.
Have tried removing the field from the views (running in production mode so can’t change the schema) and adding it back in again, can’t see any options to allow it to be filtered by.

Have tried renaming it and moving it around in the view to see if it will trigger strapi to recognise the field.