I am not quite sure how to do this. I have content type A and another content type B which references content type A using an entity reference field. So A can have multiple nodes of type B referencing it. Not B has a date field.

Now what I want to do is create a view that lists content of type A but sorted based on the date field of the latest node of type B that references it.

I am not really sure what is the best way to achieve that. Any help is highly appreciated.

1 Answer 1

  1. Make a view that lists nodes of Type B.
  2. Sort this view based on date.
  3. Add relationship based on the reference field which reference content type A.
  4. Now list the fields you want from Content type A.
  5. If you don't need fields from Content type B, hide them.
  • But since content type A can have multiple nodes of type B referencing it, the view would have duplication of type A in the list. Commented Jun 24, 2015 at 3:32
  • You can then apply distinct on that particular field.
    – Gokul N K
    Commented Jun 24, 2015 at 4:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.