I need a views block with a contextual date filter, based upon a date field of the currently viewed node.
What I've got so far:
- I already have created my base view with base filters and sorting.
- I've added a relation to the current node ("Get the actual content from a content revision")
- I've added a contextual filter Content ID, using Content ID from URL as default value
But I don't want the current node in my views block, I need the next two nodes in my views block, and I don't know how to do this part of the contextual filter:
views_node.field_date > contextual_node.field_date
Concrete use case:
I'm displaying the full view of "event node A", and on that full view of node A, I want to embed a views block, showing the next two "event nodes B and C" after the date of event node A (for selecting and ordering nodes B and C I want something similar to this pseudo-query:
select * from view_nodes where view_nodes.field_mydate > context_node.field_mydate order by view_nodes.field_mydate limit 2)