I have a content type called Author which is referred in another two content types called Novel and Book via Node Reference Module.So we can add author entity to both Book and Novel content types.
Both Novel and Book contain another field called Release Date.
Now I want to show a block which will display the name of book and name of novel in chronological order based upon the release date when user come to that corresponding Author Page.
Ex. Suppose A is an author who is author of BookA(Release Yr-2006), NovelB(Release Yr-2004),BookC(Release Year-2009). When user come to Author A page then he will be shown a block which will show the Books/Albums in chronological order like this:-
NovelB--BookA--BookC
Please suggest as how to achieve in Drupal 7.
Comments
I would suggest making a view
I would suggest making a view that would be sorted by the release date, is release field a date field or text?
I would suggets recreating the field types from Node reference to entity reference instead because in the view you can create a relationship called "Referencing entity." This allows the view to reference the books that reference the author. With node reference (as far as I know or may be another module) you can only have a one way relationship, so only the Book can display the author in the view, not vice versa.
Not only strike while the iron is hot, but make it hot by striking.
Using Node reference also we
Using Node reference also we can achieve two way relationship in Views 3. This can be achieved using reverse relationship between nodes under Relationship in Advance tab. So I am able to display book in author.
But I am not able to create a view/relationship which will display both book and novel for an author in sequential manner. Currently I created two relationship from Author-Book(Reverse) and Author-Novel(Reverse). I am using two fields and both are Title which corresponds to name of the two content types and are using existing relationship.
Two fields are:- Title(Type=Book,Relation=Author-Book(Reverse)), Title(Type=Novel, Relation=Author-Novel(Reverse)).
But I am getting output like this in ordered HTML List
1. BookA Novel B
2. BookC Novel C
I believe Union kind of thing which will merger two queries together can sort such thing. Please suggest.