This question is somewhat related to Comparing node creation and modification dates in twig I asked earlier.
For the website in question, we agreed to the following semantics of the various dates related to a node (in our case, blog posts):
- Creation date: The date the note was created.
- Changed date: The date when any of the node's modifiable settings were changed.
- First publication: The date the node was first published (using Drupal module Publication Date).
- Publication date: The date a new revision of the node has been created - in other words, the current revision's date.
In rendering the content, all is well when using
node.getRevisionCreationTime for the publication date in the relevant twig templates and display modes.
However, I what certain blocks and views to order the blog posts by publication date as defined above.
I fail to find the right settings when defining the view - I find the Views user interface incredibly complicated and not intuitive at all. In my (perhaps naive) assumption, using the Content Revision field
Authored on as sufficient, but I suspect that that doesn't always relates to the current revision.
UPDATE: An example:
So far, so good: Node creation, publication and changed times all match. But look at the "Revision created" and "Revision changed" dates - they match the corresponding node times!
The revision date 12 June 2018 is the date I want to fetch as the "Publication date" explained above.
How do I do that in a view?