apps/server/src/orchestration/ActivityPayloadProjection.test.ts      |  22 +++
 apps/server/src/orchestration/ActivityPayloadProjection.ts           |  31 +--
 apps/server/src/orchestration/Layers/ProjectionSnapshotQuery.test.ts | 157 +++++++++++++--
 apps/server/src/orchestration/Layers/ProjectionSnapshotQuery.ts      | 329 +++++++++++++++++++++++++-------
 apps/server/src/orchestration/Services/ProjectionSnapshotQuery.ts    |   4 +
 5 files changed, 449 insertions(+), 94 deletions(-)