View files from multiple (filtered) nodes

Question

I have content type Band and content type Performance. Performance has a reference field to the Band. Both content types have a media field where you can attach photos and videos. What I am trying to do is have the files from a specific Band and its Performances show up in a section (view) in the Band page. And I also want to sort them based on the Date each of the files has in its field.

All my efforts so far have been in vain. Tried to make this work with a content type view and with a file view. I feel like I will have to work with reference filters but again I can't seem to figure out how these work. I have been searching for far too long.

Any tips?

Update

Here are two screenshots of two attempts that managed to manually bring the results I am looking for, but don't really feel right.

Attempt #1

Attempt #1 tries to filter the performances and bands by taking the band name into a filter (performances have the auto label feature that adds the band name in their title). However if I have a band called "lost" and another one called "lost in space" I think I can't filter them correctly.

Attempt #2

Attempt #2 uses two reference filters (this is the first time I tried to do anything with reference filters so I guess I am using them wrong in the first place). The first reference filter brings the band node and the second brings the same band's performance nodes. If I put the node id in the preview filter below I get the correct results. However in this case that view does not accept a node id as a contextual filter because it's a file view. If I try to put a contextual filter it automatically binds to the relationship underneath it and then the reference filters don't work.

It won't let me post the reference filter views, but they are pretty basic. One takes the band id as input and renders the... band id (monkey patching at its best). The other takes the band id as input and returns the band's performances ids as a reference filter list.

Answer 1

Here is a different approach, give this a try:

• Ok, get rid off all the FILTER CRITERIA except for File: type = image
• Under Advanced, add RELATIONSHIP of [Your Entity Reference Field Name] make sure you select the one that says, "Referecing" and NOT "Referenced".
• For your FIELDS File: name and Content: title, click on them and for relationship select your Content Referencing Content from [Your Entity Reference Field Name]

• Under Advanced, add a CONTEXTUAL FILTER of nid.

  • Select provide default value
  • Content ID from url (This will automatically pick up the nid (node id) from the Band node/page.

• Lastly, would be to add SORT CRITERIA and add the date field.