I have a view that displays all reviews written by a user. One piece of information that is included in these reviews is the band that the user was playing in at the venue that the review is for. So, I have an exposed filter on the view that allows people to filter reviews by band name.
However, the exposed filter renders as a text field. I'd like to change this into a select list containing the currently viewed user's bands. So, instead of the user typing in the name of the band that they want to filter the reviews by, they can instead select a band from the list. I know that I can alter the form type within a custom module, so that it renders instead as a select box. However, I also need to populate the options of the filter with the names of the bands that the user is in.
Bands are a content type of their own. Is there a way to do this, with maybe a view or something?
EDIT - As requested in the below comment: It's D7, and it's a view of content (filtered by content type: review). The view is a block appearing in the user's profile, with a contextual filter for author UID from the page url. And yes, there is an entity reference. The user creates their bands, and then when they write a review, they select a band, which creates a reference in the review to the band.