Skip to content

Instantly share code, notes, and snippets.

@neo4j-mkd
neo4j-mkd / temporal_es.md
Last active October 14, 2025 16:46
Temporal Case Ownership Query: Single Query Solution

Temporal Case Ownership Query: Single Query Solution

The Challenge

Query: "As of March 1, 2025, which customers had open cases for Neo4j EE backups and who owned those cases at that time?"

Key requirement: The point-in-time can vary (3 days ago, 12 days ago, 1 hour ago), and we need to know who owned the case at that specific moment, since case ownership can change over time.

Data Model Design