I have a view that I need to filter based on the current logged in user, however a secondary entity reference is in-between the two. Pretty sure I need to add in PHP contextual filter code but not exactly sure what is needed.
- inventory has an entity reference to retail_location.
- retail_location has an entity reference to users.
- I need to display inventory based on the retail_location of the logged in user.