I'm working on a online magazine in drupal. I have one content type called issue with one field, the title field. And I have a content type called article the default drupal content type with a node reference field linking to issue.
I first make an issue called 'issue 01'. Then I start making some articles linked to 'issue 1' via the node reference field.
Then I make a second issue called 'issue 02'. And make some articles to go with this issue.
Now I want to make a view to show on the homepage showing all articles of the last added issue so for 'issue 02'. And when I would add a new issue called 'issue 03' the home page should automatically show the articles from this issue.
I'm trying to make this work via the relationship option and the contextual filter option in Views, the relationship is made. And the view is showing all articles. Now I want it to be filtered to showing articles of the last issue only so I thought about using the contextual filter but I can't find out a way to get, for instance, the NID of the last added issue.
Any help is welcome! Thanks in advance.