Use Content Entity Reference alias in Views Contextual Filter


I have two content types:

  • Production
  • Event

A Production is referenced in an Event and I would like to create a view that shows a list Events for a specific production. I want to use a Contextual Filter to find the production based on its URL alias.

At the moment I have a URL of /productions/6/tickets but would like it to be /productions/just-tommy-cooper-show/tickets

Is this possible?

I need it to be as automated as possible.

I appreciate anyone’s thoughts on this.

Drupal version: