How can I sort a view based on a date value in a multi-value paragraph reference field?

Question

I have a custom entity type that uses an entity reference revisions field that accepts multiple values. The referenced paragraphs contain a date field. I would like to sort the entities (descending) by the most recent date in a paragraph referenced from their fields. E.g.:

• Entity 1

  • Paragraph 0
    • Date: 1/1/2016
  • Paragraph 1
    • Date: 1/1/2017
  • Paragraph 2
    • Date: 1/1/2018

• Entity 2

  • Paragraph 0
    • Date: 2/1/2017
  • Paragraph 1
    • Date: 2/1/2018

• Entity 3

  • Paragraph 0
    • Date: 3/1/2016
  • Paragraph 1
    • Date: 3/1/2017

...should sort to: Node 2, Node 1, Node 3.

Thanks!

Answer 1

Sounds like you need to do a relationship to the paragraph reference field on your node. Which will then open up the fields on the paragraph into views. Then you might need to turn the field aggregation on in your view and add a sort on your date field selecting the MAX value