Im pretty new with advanced views and references module (Drupal 7). Im seeking for some help.
I would like to sort nodes based on node post date of the nodes that references it. So I have node type A and node type B that can reference node type A (A-one, B-many). I would like to sort type A nodes based on which has the latest Type B node.
Almost like journals that can have posts and I would like to see a list of the journals that have the newest posts.
Any idea how to approach this correctly, I seem to struggle and get some odd results.
Update: I would like to sort the journals by the newest post in them. Right now it sorts by the first post in journal. Any idea how to set this? (obviously setting the sort criteria on the sort field to ascending doesnt work, because it will just flip the list of journals...)