Drupal: Display only specific NodeReferrer field in Views

Question

I have a content type appointment with a date field that references nodes of the content type person using the Nodereference module. In the content type person I added a Nodereferrer field that shows the reverse of this references (Person -> appointments).

I now want to create a view of person nodes that shows the last appointment date of that person. I can create a View of persons with a relationship to appointments that displays all appointments, but I have no idea on how to display only the most recent one.

Any ideas on how to achieve this?

Answer 1

Personally I have not had much success with using views and node reference. It never seems to work out the relationships properly.

So my advice would be to write your own query. If you look here you can see a way to override the SQL generated by views, so you still get a lot of the goodness which comes with views.

By the way I would be very interest to see if there is a better answer than this