Logs

{
  "allocatedBytes": 328.0,
  "cpu": 2.0,
  "elapsedTimeMs": 3.0,
  "executionPlanCacheKeyHash": "AFAFBFFB",
  "id": "17460389",
  "pageFaults": 0.0,
  "pageHits": 1146.0,
  "planning": 0.0,
  "query": "match(a:AdvRateRule{deleted:true})-[r]-(b) with distinct a return a.portalorgid, a.tildaid, a.ruletype limit 10",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.3.19:54750\tserver/10.173.2.71:7687\u003e",
  "timestamp": "2026-07-27T01:13:37.662Z",
  "transactionId": 1773700.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 170.0,
  "elapsedTimeMs": 170.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24943222",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785113917370}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:38308\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:37.543Z",
  "transactionId": 12137683.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 64.0,
  "elapsedTimeMs": 65.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24943218",
  "pageFaults": 0.0,
  "pageHits": 66825.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:38308\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:37.368Z",
  "transactionId": 12137682.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 9610664.0,
  "cpu": 174.0,
  "elapsedTimeMs": 175.0,
  "executionPlanCacheKeyHash": "7644B06C",
  "id": "24943132",
  "pageFaults": 0.0,
  "pageHits": 156362.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d.tildaid AS doc_id, o.alias AS org_alias, d.primaryVersionId AS version_id,\n         d.studyId AS study_id, COALESCE(latest_ai.auto_retry_count, 0) AS current_retry_count\n    RETURN doc_id, org_alias, version_id, study_id, current_retry_count\n    ORDER BY doc_id\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 10, max_retries: 5, threshold_ms: 1785113915764}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:38308\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:35.942Z",
  "transactionId": 12137681.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 736.0,
  "cpu": 105.0,
  "elapsedTimeMs": 105.0,
  "executionPlanCacheKeyHash": "E5FA14C6",
  "id": "24943127",
  "pageFaults": 0.0,
  "pageHits": 89927.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    MATCH (d)-[:DOC_TO_ORG]-\u003e(o:Organization)\n    RETURN d.tildaid AS document_id, d.primaryVersionId AS version_id,\n           ai.tildaid AS ai_run_id, d.studyId AS study_id, ai.run_type AS run_type,\n           o.tildaid AS org_id, o.alias AS org_alias\n    ORDER BY COALESCE(ai.updatedat, ai.createdat) ASC\n    LIMIT $limit\n    ",
  "queryParameters": "{limit: 30, cutoff_ms: 1785114215655}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:38308\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:35.762Z",
  "transactionId": 12137680.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "745CE4BF",
  "id": "24943061",
  "pageFaults": 0.0,
  "pageHits": 0.0,
  "planning": 0.0,
  "query": "RETURN 1 as health_check",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/5.28.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.4.156:52770\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:34.227Z",
  "transactionId": 12137678.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4CADEF45",
  "id": "24943060",
  "pageFaults": 0.0,
  "pageHits": 0.0,
  "planning": 0.0,
  "query": "RETURN 1",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/5.28.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.4.156:52770\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:34.223Z",
  "transactionId": 12137677.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 2.0,
  "elapsedTimeMs": 2.0,
  "executionPlanCacheKeyHash": "AFAFBFFB",
  "id": "17460347",
  "pageFaults": 0.0,
  "pageHits": 1146.0,
  "planning": 0.0,
  "query": "match(a:AdvRateRule{deleted:true})-[r]-(b) with distinct a return a.portalorgid, a.tildaid, a.ruletype limit 10",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.3.19:54750\tserver/10.173.2.71:7687\u003e",
  "timestamp": "2026-07-27T01:13:32.652Z",
  "transactionId": 1773699.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 5829748.0,
  "cpu": 27473.0,
  "elapsedTimeMs": 27715.0,
  "executionPlanCacheKeyHash": "BC27D14D",
  "id": "24939381",
  "pageFaults": 0.0,
  "pageHits": 55539324.0,
  "planning": 1.0,
  "query": "\n\t\tMATCH (study:Study )-[:MANAGED_BY]-(:Inbox)-[:BELONGS_TO]-(t:Task)\n\t\tWHERE NOT EXISTS ((t)-[:BELONGS_TO]-(:Inbox{type:\"User\"}))\n\t\tCALL {\n\t\t\tWITH t\n\t\t\tMATCH (t)\u003c-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl)-[:PARTICIPANT_CONTROL]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)\n\t\t\tRETURN ptc, pw\n\t\t\tUNION ALL\n\t\t\tWITH t\n\t\t\tMATCH (t)\u003c-[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantActivity)-[:PARTICIPANT_ACTIVITY]-(pw:ParticipantWorkflow)\n\t\t\tRETURN ptc, pw\n\t\t}\n\t\tWITH DISTINCT study, t, ptc, pw\n\t\tMATCH (t)-[:BELONGS_TO]-(:Inbox)-[:MANAGED_BY]-(o:Organization)\n\t\tMATCH (ptc)-[:BELONGS_TO_TASKCONFIG]-(tc:TaskConfig)\n\t\tOPTIONAL MATCH (t)-[:BELONGS_TO]-(taskInbox:Inbox{type:\"User\"})--(taskUser:User)\n\t\tOPTIONAL MATCH (pw)-[:PARTICIPANTWORKFLOW_TO_SCOPE]-(:StudySiteActor)-[:STUDYSITEACTOR_TO_ACTOR]-(:Actor{delpending:false})-[:FOR_USER]-(user:User)\n\t\tOPTIONAL MATCH (pw)-[:PARTICIPANTWORKFLOW_TO_SCOPE]-(:DslPlanDefinition)-[:PLAN_DEFINITION_TO_SITE]-(scopeSite:Site)-[:SITE_TO_SMO]-(:Smo)-[:IS_AN_ORG]-(o)\n\t\tCALL {\n\t\t\tWITH study\n\t\t\tOPTIONAL MATCH (study)-[:STUDY_TO_ACTOR]-(a:Actor{delpending:false})-[:FOR_USER]-(u:User),\n\t\t\t\t(a)-[:APPOINTED_AS]-(r:Role)\n\t\t\tWHERE r.name IN [\"principal_investigator\", \"study_admin\", \"regulatory_analyst\"]\n\t\t\tRETURN collect(DISTINCT CASE WHEN r.name = \"principal_investigator\" THEN u.tildaid END) AS piTildaid,\n\t\t\t\tcollect(DISTINCT CASE WHEN r.name = \"study_admin\" THEN u.tildaid END) AS smoTildaid,\n\t\t\t\tcollect(DISTINCT CASE WHEN r.name = \"regulatory_analyst\" THEN u.tildaid END) AS raTildaid\n\t\t}\n\t\tCALL {\n\t\t\tWITH o\n\t\t\tOPTIONAL MATCH (o)-[:ORGANIZATION_TO_ACTOR]-(a:Actor{delpending:false})-[:FOR_USER]-(u:User),\n\t\t\t\t(a)-[:APPOINTED_AS]-(:Role{name:\"org_admin\"})\n\t\t\tRETURN collect(DISTINCT u.tildaid) AS adminTildaid\n\t\t}\n\t\tCALL {\n\t\t\tWITH scopeSite\n\t\t\tOPTIONAL MATCH (scopeSite)-[:STAFF_TO_ACTOR]-(a:Actor{delpending:false})-[:FOR_USER]-(u:User),\n\t\t\t\t(a)-[:APPOINTED_AS]-(:Role{name:\"site_admin\"})\n\t\t\tRETURN collect(DISTINCT u.tildaid) AS siteAdminTildaid\n\t\t}\n\t\tRETURN DISTINCT t AS task, apoc.convert.toJson({userTildaid: user.tildaid, userName: user.name,\n\t\t\tPITildaid: piTildaid, studyOwnerTildaid: smoTildaid, regAnalystTildaid: raTildaid,\n\t\t\torgAdminTildaid: adminTildaid, studyName: study.name, siteName: scopeSite.name,\n\t\t\tsiteAdminTildaid: siteAdminTildaid}) AS details, tc.who AS dsnWho, o.alias AS orgAlias,\n\t\t\ttaskInbox, taskUser.tildaid AS taskUserId\n\t\tSKIP 400 LIMIT 400",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.0.236:57644\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:27.798Z",
  "transactionId": 12136112.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 2.0,
  "elapsedTimeMs": 2.0,
  "executionPlanCacheKeyHash": "AFAFBFFB",
  "id": "17460281",
  "pageFaults": 0.0,
  "pageHits": 1146.0,
  "planning": 0.0,
  "query": "match(a:AdvRateRule{deleted:true})-[r]-(b) with distinct a return a.portalorgid, a.tildaid, a.ruletype limit 10",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.3.19:54750\tserver/10.173.2.71:7687\u003e",
  "timestamp": "2026-07-27T01:13:27.643Z",
  "transactionId": 1773698.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "745CE4BF",
  "id": "24942467",
  "pageFaults": 0.0,
  "pageHits": 0.0,
  "planning": 0.0,
  "query": "RETURN 1 as health_check",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/5.28.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.4.156:52770\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:24.226Z",
  "transactionId": 12137673.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4CADEF45",
  "id": "24942465",
  "pageFaults": 0.0,
  "pageHits": 0.0,
  "planning": 0.0,
  "query": "RETURN 1",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/5.28.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.4.156:52770\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:24.221Z",
  "transactionId": 12137672.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "745CE4BF",
  "id": "24942458",
  "pageFaults": 0.0,
  "pageHits": 0.0,
  "planning": 0.0,
  "query": "RETURN 1 as health_check",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/5.28.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.4.156:52770\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:24.125Z",
  "transactionId": 12137671.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4CADEF45",
  "id": "24942457",
  "pageFaults": 0.0,
  "pageHits": 0.0,
  "planning": 0.0,
  "query": "RETURN 1",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/5.28.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.4.156:52770\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:24.121Z",
  "transactionId": 12137670.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 2.0,
  "elapsedTimeMs": 2.0,
  "executionPlanCacheKeyHash": "AFAFBFFB",
  "id": "17460237",
  "pageFaults": 0.0,
  "pageHits": 1146.0,
  "planning": 0.0,
  "query": "match(a:AdvRateRule{deleted:true})-[r]-(b) with distinct a return a.portalorgid, a.tildaid, a.ruletype limit 10",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.3.19:54750\tserver/10.173.2.71:7687\u003e",
  "timestamp": "2026-07-27T01:13:22.635Z",
  "transactionId": 1773697.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7666360.0,
  "cpu": 204.0,
  "elapsedTimeMs": 204.0,
  "executionPlanCacheKeyHash": "590286C5",
  "id": "24942354",
  "pageFaults": 0.0,
  "pageHits": 156448.0,
  "planning": 0.0,
  "query": "\n    MATCH (o:Organization{orgType:\"CRO\"})-[:DOC_TO_ORG]-(d:Document)-[:INCLUDES]-(f:Folder)\n        WHERE f.name IN [\u0027Staging\u0027, \u0027Pre-Staging\u0027]\n        AND d.delpending = false AND d.aiEnabled = true AND d.studyId \u003c\u003e \"\"\n        AND d.primaryVersionId IS NOT NULL AND d.primaryVersionId \u003c\u003e \"\"\n    OPTIONAL MATCH (d)\u003c-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun)\n    WITH o, d, ai\n    ORDER BY d.tildaid, COALESCE(ai.updatedat, ai.createdat) DESC\n    WITH o, d, collect(ai)[0] AS latest_ai\n    WHERE (\n        latest_ai IS NULL\n        OR latest_ai.status = \"aborted\"\n        OR (\n            latest_ai.status = \"failed\"\n            AND COALESCE(latest_ai.auto_retry_count, 0) \u003c $max_retries\n            AND COALESCE(latest_ai.updatedat, latest_ai.createdat) \u003c $threshold_ms\n        )\n    )\n    WITH d\n    RETURN count(d) AS total\n    ",
  "queryParameters": "{max_retries: 5, threshold_ms: 1785113901806}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:38308\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:22.013Z",
  "transactionId": 12137669.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 73.0,
  "elapsedTimeMs": 73.0,
  "executionPlanCacheKeyHash": "E4907905",
  "id": "24942350",
  "pageFaults": 0.0,
  "pageHits": 66849.0,
  "planning": 0.0,
  "query": "\n    MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]-\u003e(d:Document)\n    WHERE d.aiEnabled = true\n    AND (\n        (ai.status = \"in_progress\" AND ($cutoff_ms \u003c= 0 OR COALESCE(ai.updatedat, ai.createdat) \u003c $cutoff_ms))\n        OR ai.status = \"aborted\"\n    )\n    RETURN count(ai) AS total\n    ",
  "queryParameters": "{cutoff_ms: 0}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-python/6.2.0 Python/3.12.13-final-0 (linux)\t\tclient/10.129.3.15:38308\tserver/10.173.0.8:7687\u003e",
  "timestamp": "2026-07-27T01:13:21.804Z",
  "transactionId": 12137668.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 724.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942209",
  "pageFaults": 0.0,
  "pageHits": 6.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u00275fda6743-4617-464f-9598-5ffebf341fa6\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:19.021Z",
  "transactionId": 12137665.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942208",
  "pageFaults": 0.0,
  "pageHits": 12.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u00275fda6743-4617-464f-9598-5ffebf341fa6\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:19.011Z",
  "transactionId": 12137664.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942206",
  "pageFaults": 0.0,
  "pageHits": 13.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u00275fda6743-4617-464f-9598-5ffebf341fa6\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:19.006Z",
  "transactionId": 12137664.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942205",
  "pageFaults": 0.0,
  "pageHits": 15.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u00275fda6743-4617-464f-9598-5ffebf341fa6\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.995Z",
  "transactionId": 12137663.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942203",
  "pageFaults": 0.0,
  "pageHits": 8.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u00275fda6743-4617-464f-9598-5ffebf341fa6\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.983Z",
  "transactionId": 12137662.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 724.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942202",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027322547e7-b0fd-4d98-963d-afb231950377\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.970Z",
  "transactionId": 12137661.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942200",
  "pageFaults": 0.0,
  "pageHits": 8.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027322547e7-b0fd-4d98-963d-afb231950377\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.959Z",
  "transactionId": 12137660.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942199",
  "pageFaults": 0.0,
  "pageHits": 9.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027322547e7-b0fd-4d98-963d-afb231950377\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.954Z",
  "transactionId": 12137660.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942198",
  "pageFaults": 0.0,
  "pageHits": 13.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027322547e7-b0fd-4d98-963d-afb231950377\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.943Z",
  "transactionId": 12137659.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942196",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027322547e7-b0fd-4d98-963d-afb231950377\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.930Z",
  "transactionId": 12137658.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 724.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942195",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u00276ff3918b-05db-4310-bde3-9019341f582a\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.918Z",
  "transactionId": 12137657.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942193",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u00276ff3918b-05db-4310-bde3-9019341f582a\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.906Z",
  "transactionId": 12137656.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942192",
  "pageFaults": 0.0,
  "pageHits": 12.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u00276ff3918b-05db-4310-bde3-9019341f582a\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.901Z",
  "transactionId": 12137656.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942190",
  "pageFaults": 0.0,
  "pageHits": 16.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u00276ff3918b-05db-4310-bde3-9019341f582a\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.889Z",
  "transactionId": 12137655.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942189",
  "pageFaults": 0.0,
  "pageHits": 8.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u00276ff3918b-05db-4310-bde3-9019341f582a\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.877Z",
  "transactionId": 12137654.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 724.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942187",
  "pageFaults": 0.0,
  "pageHits": 6.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027c10303ac-4c50-40fa-9713-4e535108f3b7\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.864Z",
  "transactionId": 12137653.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942185",
  "pageFaults": 0.0,
  "pageHits": 17.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027c10303ac-4c50-40fa-9713-4e535108f3b7\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.831Z",
  "transactionId": 12137652.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942184",
  "pageFaults": 0.0,
  "pageHits": 18.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027c10303ac-4c50-40fa-9713-4e535108f3b7\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.826Z",
  "transactionId": 12137652.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942182",
  "pageFaults": 0.0,
  "pageHits": 26.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027c10303ac-4c50-40fa-9713-4e535108f3b7\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.814Z",
  "transactionId": 12137651.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942180",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027c10303ac-4c50-40fa-9713-4e535108f3b7\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.801Z",
  "transactionId": 12137650.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 724.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942179",
  "pageFaults": 0.0,
  "pageHits": 5.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u002757c957cb-a23f-4f3a-8bf1-bb9e566a2b6e\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.788Z",
  "transactionId": 12137649.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942177",
  "pageFaults": 0.0,
  "pageHits": 9.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u002757c957cb-a23f-4f3a-8bf1-bb9e566a2b6e\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.776Z",
  "transactionId": 12137648.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942176",
  "pageFaults": 0.0,
  "pageHits": 10.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u002757c957cb-a23f-4f3a-8bf1-bb9e566a2b6e\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.770Z",
  "transactionId": 12137648.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942175",
  "pageFaults": 0.0,
  "pageHits": 14.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u002757c957cb-a23f-4f3a-8bf1-bb9e566a2b6e\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.758Z",
  "transactionId": 12137647.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942173",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u002757c957cb-a23f-4f3a-8bf1-bb9e566a2b6e\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.745Z",
  "transactionId": 12137646.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7656.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942171",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 25, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027d4a889a1-a6b0-4bdd-9ede-fae571005b67\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.732Z",
  "transactionId": 12137645.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942170",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027d4a889a1-a6b0-4bdd-9ede-fae571005b67\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.727Z",
  "transactionId": 12137645.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E5CF3BBC",
  "id": "24942169",
  "pageFaults": 0.0,
  "pageHits": 6.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $wo})-[:WORK_ORDER_TO_ORGANIZATION]-\u003e(o:Organization)\n            RETURN COALESCE(o.reminderApprovalRequired, true) AS approval_required\n            ",
  "queryParameters": "{wo: \u0027d4a889a1-a6b0-4bdd-9ede-fae571005b67\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.716Z",
  "transactionId": 12137644.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7560.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942167",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027d4a889a1-a6b0-4bdd-9ede-fae571005b67\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.704Z",
  "transactionId": 12137643.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942165",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027d4a889a1-a6b0-4bdd-9ede-fae571005b67\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.699Z",
  "transactionId": 12137643.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942164",
  "pageFaults": 0.0,
  "pageHits": 9.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027d4a889a1-a6b0-4bdd-9ede-fae571005b67\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.687Z",
  "transactionId": 12137642.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942162",
  "pageFaults": 0.0,
  "pageHits": 9.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027d4a889a1-a6b0-4bdd-9ede-fae571005b67\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.675Z",
  "transactionId": 12137641.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 776.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942160",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027485f1414-f260-45ca-806c-a1c7843624bc\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.662Z",
  "transactionId": 12137640.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942159",
  "pageFaults": 0.0,
  "pageHits": 4.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027485f1414-f260-45ca-806c-a1c7843624bc\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.651Z",
  "transactionId": 12137639.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942158",
  "pageFaults": 0.0,
  "pageHits": 6.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027485f1414-f260-45ca-806c-a1c7843624bc\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.646Z",
  "transactionId": 12137639.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942156",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027485f1414-f260-45ca-806c-a1c7843624bc\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.634Z",
  "transactionId": 12137638.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942155",
  "pageFaults": 0.0,
  "pageHits": 9.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027485f1414-f260-45ca-806c-a1c7843624bc\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.622Z",
  "transactionId": 12137637.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 724.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942153",
  "pageFaults": 0.0,
  "pageHits": 6.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u002788f04d6a-d740-47c4-bc29-a959b502598e\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.609Z",
  "transactionId": 12137636.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "C23BE7B4",
  "id": "24942152",
  "pageFaults": 0.0,
  "pageHits": 0.0,
  "planning": 0.0,
  "query": "CREATE (a:WorkplanInstanceEvent{deltimestamp:0}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=0,a.holdbitmap=0,a.delpending=false,a.instanceId=\"4f4a2dc3-117b-4b69-a1c1-8944eb009099\",a.orgId=\"a5fb9821-522a-4061-823f-b0a66173a204\",a.eventType=\"sweeper_send_blocked\",a.requestId=\"\",a.summary=\"Sweeper skipped send: 1 unlinked work order(s)\",a.payloadJson=\u0027{\"reason\":\"unlinked_work_orders\",\"unlinkedWorkOrderCount\":1}\u0027 RETURN a.tildaid, a.createdat",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:58524\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.602Z",
  "transactionId": 12137635.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "CB2C51F3",
  "id": "24942151",
  "pageFaults": 0.0,
  "pageHits": 414.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_INSTANCE]-\u003e(wp:WorkPlanInstance{tildaid:\"4f4a2dc3-117b-4b69-a1c1-8944eb009099\"})\n\t\tRETURN org.tildaid as oid\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:58524\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.598Z",
  "transactionId": 12137635.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942150",
  "pageFaults": 0.0,
  "pageHits": 4.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u002788f04d6a-d740-47c4-bc29-a959b502598e\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.598Z",
  "transactionId": 12137634.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942148",
  "pageFaults": 0.0,
  "pageHits": 6.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u002788f04d6a-d740-47c4-bc29-a959b502598e\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.593Z",
  "transactionId": 12137634.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942146",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u002788f04d6a-d740-47c4-bc29-a959b502598e\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.580Z",
  "transactionId": 12137633.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942144",
  "pageFaults": 0.0,
  "pageHits": 10.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u002788f04d6a-d740-47c4-bc29-a959b502598e\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.567Z",
  "transactionId": 12137632.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "C23BE7B4",
  "id": "24942143",
  "pageFaults": 0.0,
  "pageHits": 0.0,
  "planning": 0.0,
  "query": "CREATE (a:WorkplanInstanceEvent{deltimestamp:0}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=0,a.holdbitmap=0,a.delpending=false,a.instanceId=\"8cb2d38c-046c-4910-bb36-a02d9b856938\",a.orgId=\"aa59151d-6c89-4c13-811b-0dffb1ed1693\",a.eventType=\"sweeper_send_blocked\",a.requestId=\"\",a.summary=\"Sweeper skipped send: 1 unlinked work order(s)\",a.payloadJson=\u0027{\"reason\":\"unlinked_work_orders\",\"unlinkedWorkOrderCount\":1}\u0027 RETURN a.tildaid, a.createdat",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:58524\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.565Z",
  "transactionId": 12137631.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "CB2C51F3",
  "id": "24942142",
  "pageFaults": 0.0,
  "pageHits": 432.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_INSTANCE]-\u003e(wp:WorkPlanInstance{tildaid:\"8cb2d38c-046c-4910-bb36-a02d9b856938\"})\n\t\tRETURN org.tildaid as oid\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:58524\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.562Z",
  "transactionId": 12137631.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 828.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942141",
  "pageFaults": 0.0,
  "pageHits": 9.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u00278b2449c7-0c34-47c4-b4b9-ae5867fb2d45\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.554Z",
  "transactionId": 12137630.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "0CD31179",
  "id": "13457766",
  "pageFaults": 0.0,
  "pageHits": 420.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (wp:WorkPlanInstance{tildaid:\"8cb2d38c-046c-4910-bb36-a02d9b856938\"})-[:WORKPLAN_INSTANCE_TO_MILESTONE]-\u003e(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]-\u003e(item:WorkplanInstanceMilestoneItem)\n\t\tWHERE item.itemType = \"Workorder\"\n\t\t  AND coalesce(item.skippedAt, 0) = 0\n\t\t  AND coalesce(item.notApplicableAt, 0) = 0\n\t\t  AND coalesce(item.workOrderCompletedAt, 0) = 0\n\t\t  AND coalesce(item.workOrderId, \"\") = \"\"\n\t\tRETURN count(item) AS n\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.553Z",
  "transactionId": 1753604.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "0CD31179",
  "id": "13457765",
  "pageFaults": 0.0,
  "pageHits": 418.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (wp:WorkPlanInstance{tildaid:\"4f4a2dc3-117b-4b69-a1c1-8944eb009099\"})-[:WORKPLAN_INSTANCE_TO_MILESTONE]-\u003e(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]-\u003e(item:WorkplanInstanceMilestoneItem)\n\t\tWHERE item.itemType = \"Workorder\"\n\t\t  AND coalesce(item.skippedAt, 0) = 0\n\t\t  AND coalesce(item.notApplicableAt, 0) = 0\n\t\t  AND coalesce(item.workOrderCompletedAt, 0) = 0\n\t\t  AND coalesce(item.workOrderId, \"\") = \"\"\n\t\tRETURN count(item) AS n\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.546Z",
  "transactionId": 1753603.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942139",
  "pageFaults": 0.0,
  "pageHits": 12.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u00278b2449c7-0c34-47c4-b4b9-ae5867fb2d45\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.542Z",
  "transactionId": 12137629.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 832.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "81C085B2",
  "id": "24942137",
  "pageFaults": 0.0,
  "pageHits": 415.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (wp:WorkPlanInstance)\n\t\tWHERE wp.instanceReadyDeterminationState = \"pending\"\n\t\t  AND wp.state \u003c\u003e \"archived\"\n\t\tRETURN wp.tildaid AS id\n\t\tORDER BY coalesce(wp.instanceReadyDeterminationUpdatedAt, 0) ASC\n\t\tLIMIT 50\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:58524\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.538Z",
  "transactionId": 12137628.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942138",
  "pageFaults": 0.0,
  "pageHits": 13.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u00278b2449c7-0c34-47c4-b4b9-ae5867fb2d45\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.537Z",
  "transactionId": 12137629.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 1888.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B9F9D65",
  "id": "24942136",
  "pageFaults": 0.0,
  "pageHits": 417.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (wp:WorkPlanInstance)\n\t\tWHERE wp.instanceReadyDeterminationState IN [\"in_progress\", \"in_progress_and_pending\"]\n\t\t  AND wp.state \u003c\u003e \"archived\"\n\t\tOPTIONAL MATCH (wp)\u003c-[:WORKPLAN_JOB_TO_OBJ]-(job:WorkplanJob)\n\t\tWITH wp, count(job) AS jobN\n\t\tWHERE jobN = 0\n\t\tRETURN wp.tildaid AS id\n\t\tLIMIT 50\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:58524\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.533Z",
  "transactionId": 12137628.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942135",
  "pageFaults": 0.0,
  "pageHits": 17.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u00278b2449c7-0c34-47c4-b4b9-ae5867fb2d45\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.526Z",
  "transactionId": 12137627.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 19512.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "3832EC22",
  "id": "13457758",
  "pageFaults": 0.0,
  "pageHits": 17.0,
  "planning": 0.0,
  "query": "\nUNWIND $site_ids AS sid\nOPTIONAL MATCH (s:Site {tildaid: sid, delpending: false})\nOPTIONAL MATCH (s)\u003c-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]-\u003e(st:Study {tildaid: $study_id, delpending: false})\nOPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]-\u003e(actor:Actor {delpending: false})-[:FOR_USER]-\u003e(u:User)\nOPTIONAL MATCH (pd)-[copdc:PLAN_DEFINITION_TO_CLINOP_CONTACT]-\u003e(co:ClinOp {deltimestamp: 0})-[:FOR_USER]-\u003e(cou:User)\nWITH sid, s,\n  collect(DISTINCT CASE\n    WHEN pdc IS NOT NULL AND actor IS NOT NULL AND (u IS NULL OR u.status \u003c\u003e $deleted_status) THEN {\n    t: pdc.type,\n    p: coalesce(pdc.isPrimary, false),\n    e: coalesce(u.email, \"\")\n  } END) AS actorContactRows,\n  collect(DISTINCT CASE\n    WHEN copdc IS NOT NULL AND co IS NOT NULL AND (cou IS NULL OR cou.status \u003c\u003e $deleted_status) THEN {\n    t: copdc.type,\n    p: coalesce(copdc.isPrimary, false),\n    e: coalesce(cou.email, \"\")\n  } END) AS clinopContactRows\nWITH sid, s, actorContactRows + clinopContactRows AS pdContactRowsRaw\nWITH sid, s,\n  [row IN pdContactRowsRaw WHERE row IS NOT NULL AND row.t IS NOT NULL AND row.e IS NOT NULL AND row.e \u003c\u003e \"\"] AS pd_rows\nRETURN sid AS site_id, coalesce(s.name, \"\") AS site_name, pd_rows\n",
  "queryParameters": "{deleted_status: \u0027Deleted\u0027, site_ids: [\u00276ef91479-dbf6-4a3b-82b9-4c07b66b8eb4\u0027], study_id: \u002716ffa942-94ca-4e1c-88f7-e0d87180dfe8\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.525Z",
  "transactionId": 1753602.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B774BFC",
  "id": "13457757",
  "pageFaults": 0.0,
  "pageHits": 414.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (instance:WorkPlanInstance{tildaid:\"a1492aa6-ba07-49a9-aa99-0758bbdd18d3\"})-[:WORKPLAN_TO_SITE]-\u003e(site:Site)\n\t\tRETURN site.tildaid as siteId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.519Z",
  "transactionId": 1753601.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942133",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u00278b2449c7-0c34-47c4-b4b9-ae5867fb2d45\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.514Z",
  "transactionId": 12137626.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "682A7B96",
  "id": "13457754",
  "pageFaults": 0.0,
  "pageHits": 329.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg{tildaid:\"92f49070-1232-4531-bb13-73157a75b154\"})-[:WORKPLAN_CFG_TO_STUDY]-\u003e(study:Study)\n\t\tRETURN study.tildaid as studyId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.512Z",
  "transactionId": 1753600.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 19512.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "3832EC22",
  "id": "13457753",
  "pageFaults": 0.0,
  "pageHits": 46.0,
  "planning": 0.0,
  "query": "\nUNWIND $site_ids AS sid\nOPTIONAL MATCH (s:Site {tildaid: sid, delpending: false})\nOPTIONAL MATCH (s)\u003c-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]-\u003e(st:Study {tildaid: $study_id, delpending: false})\nOPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]-\u003e(actor:Actor {delpending: false})-[:FOR_USER]-\u003e(u:User)\nOPTIONAL MATCH (pd)-[copdc:PLAN_DEFINITION_TO_CLINOP_CONTACT]-\u003e(co:ClinOp {deltimestamp: 0})-[:FOR_USER]-\u003e(cou:User)\nWITH sid, s,\n  collect(DISTINCT CASE\n    WHEN pdc IS NOT NULL AND actor IS NOT NULL AND (u IS NULL OR u.status \u003c\u003e $deleted_status) THEN {\n    t: pdc.type,\n    p: coalesce(pdc.isPrimary, false),\n    e: coalesce(u.email, \"\")\n  } END) AS actorContactRows,\n  collect(DISTINCT CASE\n    WHEN copdc IS NOT NULL AND co IS NOT NULL AND (cou IS NULL OR cou.status \u003c\u003e $deleted_status) THEN {\n    t: copdc.type,\n    p: coalesce(copdc.isPrimary, false),\n    e: coalesce(cou.email, \"\")\n  } END) AS clinopContactRows\nWITH sid, s, actorContactRows + clinopContactRows AS pdContactRowsRaw\nWITH sid, s,\n  [row IN pdContactRowsRaw WHERE row IS NOT NULL AND row.t IS NOT NULL AND row.e IS NOT NULL AND row.e \u003c\u003e \"\"] AS pd_rows\nRETURN sid AS site_id, coalesce(s.name, \"\") AS site_name, pd_rows\n",
  "queryParameters": "{deleted_status: \u0027Deleted\u0027, site_ids: [\u0027f17cfa1f-97b5-4f9f-9b7b-a7d3cb0420a4\u0027], study_id: \u0027e47593bd-8d16-45f9-bda7-6875606eecc7\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.506Z",
  "transactionId": 1753599.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 828.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942131",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027c6b45988-3afb-4efc-843d-efe22819df8a\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.500Z",
  "transactionId": 12137625.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B774BFC",
  "id": "13457751",
  "pageFaults": 0.0,
  "pageHits": 414.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (instance:WorkPlanInstance{tildaid:\"a947c13c-168f-4975-a246-376dd9402562\"})-[:WORKPLAN_TO_SITE]-\u003e(site:Site)\n\t\tRETURN site.tildaid as siteId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.500Z",
  "transactionId": 1753598.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "682A7B96",
  "id": "13457750",
  "pageFaults": 0.0,
  "pageHits": 329.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg{tildaid:\"b63053ca-d6b2-47b2-9dbb-effaf732dd75\"})-[:WORKPLAN_CFG_TO_STUDY]-\u003e(study:Study)\n\t\tRETURN study.tildaid as studyId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.493Z",
  "transactionId": 1753597.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942129",
  "pageFaults": 0.0,
  "pageHits": 17.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027c6b45988-3afb-4efc-843d-efe22819df8a\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.489Z",
  "transactionId": 12137624.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 19512.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "3832EC22",
  "id": "13457747",
  "pageFaults": 0.0,
  "pageHits": 29.0,
  "planning": 0.0,
  "query": "\nUNWIND $site_ids AS sid\nOPTIONAL MATCH (s:Site {tildaid: sid, delpending: false})\nOPTIONAL MATCH (s)\u003c-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]-\u003e(st:Study {tildaid: $study_id, delpending: false})\nOPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]-\u003e(actor:Actor {delpending: false})-[:FOR_USER]-\u003e(u:User)\nOPTIONAL MATCH (pd)-[copdc:PLAN_DEFINITION_TO_CLINOP_CONTACT]-\u003e(co:ClinOp {deltimestamp: 0})-[:FOR_USER]-\u003e(cou:User)\nWITH sid, s,\n  collect(DISTINCT CASE\n    WHEN pdc IS NOT NULL AND actor IS NOT NULL AND (u IS NULL OR u.status \u003c\u003e $deleted_status) THEN {\n    t: pdc.type,\n    p: coalesce(pdc.isPrimary, false),\n    e: coalesce(u.email, \"\")\n  } END) AS actorContactRows,\n  collect(DISTINCT CASE\n    WHEN copdc IS NOT NULL AND co IS NOT NULL AND (cou IS NULL OR cou.status \u003c\u003e $deleted_status) THEN {\n    t: copdc.type,\n    p: coalesce(copdc.isPrimary, false),\n    e: coalesce(cou.email, \"\")\n  } END) AS clinopContactRows\nWITH sid, s, actorContactRows + clinopContactRows AS pdContactRowsRaw\nWITH sid, s,\n  [row IN pdContactRowsRaw WHERE row IS NOT NULL AND row.t IS NOT NULL AND row.e IS NOT NULL AND row.e \u003c\u003e \"\"] AS pd_rows\nRETURN sid AS site_id, coalesce(s.name, \"\") AS site_name, pd_rows\n",
  "queryParameters": "{deleted_status: \u0027Deleted\u0027, site_ids: [\u0027a6259678-9d0f-4311-8051-d1dca2333297\u0027], study_id: \u002716ffa942-94ca-4e1c-88f7-e0d87180dfe8\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.487Z",
  "transactionId": 1753596.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942128",
  "pageFaults": 0.0,
  "pageHits": 18.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027c6b45988-3afb-4efc-843d-efe22819df8a\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.484Z",
  "transactionId": 12137624.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B774BFC",
  "id": "13457745",
  "pageFaults": 0.0,
  "pageHits": 414.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (instance:WorkPlanInstance{tildaid:\"344bb43b-c114-414a-9ede-3024085e25ec\"})-[:WORKPLAN_TO_SITE]-\u003e(site:Site)\n\t\tRETURN site.tildaid as siteId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.480Z",
  "transactionId": 1753595.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "682A7B96",
  "id": "13457744",
  "pageFaults": 0.0,
  "pageHits": 329.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg{tildaid:\"aa651aca-e3b1-437b-91c0-1a782428010b\"})-[:WORKPLAN_CFG_TO_STUDY]-\u003e(study:Study)\n\t\tRETURN study.tildaid as studyId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.473Z",
  "transactionId": 1753594.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942126",
  "pageFaults": 0.0,
  "pageHits": 30.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027c6b45988-3afb-4efc-843d-efe22819df8a\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.471Z",
  "transactionId": 12137623.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 19512.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "3832EC22",
  "id": "13457741",
  "pageFaults": 0.0,
  "pageHits": 28.0,
  "planning": 0.0,
  "query": "\nUNWIND $site_ids AS sid\nOPTIONAL MATCH (s:Site {tildaid: sid, delpending: false})\nOPTIONAL MATCH (s)\u003c-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]-\u003e(st:Study {tildaid: $study_id, delpending: false})\nOPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]-\u003e(actor:Actor {delpending: false})-[:FOR_USER]-\u003e(u:User)\nOPTIONAL MATCH (pd)-[copdc:PLAN_DEFINITION_TO_CLINOP_CONTACT]-\u003e(co:ClinOp {deltimestamp: 0})-[:FOR_USER]-\u003e(cou:User)\nWITH sid, s,\n  collect(DISTINCT CASE\n    WHEN pdc IS NOT NULL AND actor IS NOT NULL AND (u IS NULL OR u.status \u003c\u003e $deleted_status) THEN {\n    t: pdc.type,\n    p: coalesce(pdc.isPrimary, false),\n    e: coalesce(u.email, \"\")\n  } END) AS actorContactRows,\n  collect(DISTINCT CASE\n    WHEN copdc IS NOT NULL AND co IS NOT NULL AND (cou IS NULL OR cou.status \u003c\u003e $deleted_status) THEN {\n    t: copdc.type,\n    p: coalesce(copdc.isPrimary, false),\n    e: coalesce(cou.email, \"\")\n  } END) AS clinopContactRows\nWITH sid, s, actorContactRows + clinopContactRows AS pdContactRowsRaw\nWITH sid, s,\n  [row IN pdContactRowsRaw WHERE row IS NOT NULL AND row.t IS NOT NULL AND row.e IS NOT NULL AND row.e \u003c\u003e \"\"] AS pd_rows\nRETURN sid AS site_id, coalesce(s.name, \"\") AS site_name, pd_rows\n",
  "queryParameters": "{deleted_status: \u0027Deleted\u0027, site_ids: [\u0027a6259678-9d0f-4311-8051-d1dca2333297\u0027], study_id: \u00270a62f219-a803-482f-8973-ab67b1a3baf7\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.467Z",
  "transactionId": 1753593.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B774BFC",
  "id": "13457740",
  "pageFaults": 0.0,
  "pageHits": 416.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (instance:WorkPlanInstance{tildaid:\"272b7c49-648b-454b-b9e4-34bbc9c082cc\"})-[:WORKPLAN_TO_SITE]-\u003e(site:Site)\n\t\tRETURN site.tildaid as siteId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.461Z",
  "transactionId": 1753592.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942124",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027c6b45988-3afb-4efc-843d-efe22819df8a\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.458Z",
  "transactionId": 12137622.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "682A7B96",
  "id": "13457738",
  "pageFaults": 0.0,
  "pageHits": 329.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg{tildaid:\"a546762b-b73b-495c-b06f-543822164be1\"})-[:WORKPLAN_CFG_TO_STUDY]-\u003e(study:Study)\n\t\tRETURN study.tildaid as studyId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.454Z",
  "transactionId": 1753591.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 19512.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "3832EC22",
  "id": "13457737",
  "pageFaults": 0.0,
  "pageHits": 22.0,
  "planning": 0.0,
  "query": "\nUNWIND $site_ids AS sid\nOPTIONAL MATCH (s:Site {tildaid: sid, delpending: false})\nOPTIONAL MATCH (s)\u003c-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]-\u003e(st:Study {tildaid: $study_id, delpending: false})\nOPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]-\u003e(actor:Actor {delpending: false})-[:FOR_USER]-\u003e(u:User)\nOPTIONAL MATCH (pd)-[copdc:PLAN_DEFINITION_TO_CLINOP_CONTACT]-\u003e(co:ClinOp {deltimestamp: 0})-[:FOR_USER]-\u003e(cou:User)\nWITH sid, s,\n  collect(DISTINCT CASE\n    WHEN pdc IS NOT NULL AND actor IS NOT NULL AND (u IS NULL OR u.status \u003c\u003e $deleted_status) THEN {\n    t: pdc.type,\n    p: coalesce(pdc.isPrimary, false),\n    e: coalesce(u.email, \"\")\n  } END) AS actorContactRows,\n  collect(DISTINCT CASE\n    WHEN copdc IS NOT NULL AND co IS NOT NULL AND (cou IS NULL OR cou.status \u003c\u003e $deleted_status) THEN {\n    t: copdc.type,\n    p: coalesce(copdc.isPrimary, false),\n    e: coalesce(cou.email, \"\")\n  } END) AS clinopContactRows\nWITH sid, s, actorContactRows + clinopContactRows AS pdContactRowsRaw\nWITH sid, s,\n  [row IN pdContactRowsRaw WHERE row IS NOT NULL AND row.t IS NOT NULL AND row.e IS NOT NULL AND row.e \u003c\u003e \"\"] AS pd_rows\nRETURN sid AS site_id, coalesce(s.name, \"\") AS site_name, pd_rows\n",
  "queryParameters": "{deleted_status: \u0027Deleted\u0027, site_ids: [\u0027cec6713e-0087-4942-91db-316352bbca2c\u0027], study_id: \u00275b971f19-ded8-4c5d-8649-5b2a96841d67\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.448Z",
  "transactionId": 1753590.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 776.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942122",
  "pageFaults": 0.0,
  "pageHits": 8.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027d74db13c-677a-4fd3-89f6-02349b34abfb\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.446Z",
  "transactionId": 12137621.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B774BFC",
  "id": "13457734",
  "pageFaults": 0.0,
  "pageHits": 415.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (instance:WorkPlanInstance{tildaid:\"bad745ed-c7c6-496e-bd2b-1cbc61040198\"})-[:WORKPLAN_TO_SITE]-\u003e(site:Site)\n\t\tRETURN site.tildaid as siteId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.442Z",
  "transactionId": 1753589.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "682A7B96",
  "id": "13457733",
  "pageFaults": 0.0,
  "pageHits": 329.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg{tildaid:\"cb82212d-9ee3-4739-9c4f-bec323411efb\"})-[:WORKPLAN_CFG_TO_STUDY]-\u003e(study:Study)\n\t\tRETURN study.tildaid as studyId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.436Z",
  "transactionId": 1753588.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942121",
  "pageFaults": 0.0,
  "pageHits": 6.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027d74db13c-677a-4fd3-89f6-02349b34abfb\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.434Z",
  "transactionId": 12137620.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 19512.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "3832EC22",
  "id": "13457731",
  "pageFaults": 0.0,
  "pageHits": 28.0,
  "planning": 0.0,
  "query": "\nUNWIND $site_ids AS sid\nOPTIONAL MATCH (s:Site {tildaid: sid, delpending: false})\nOPTIONAL MATCH (s)\u003c-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]-\u003e(st:Study {tildaid: $study_id, delpending: false})\nOPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]-\u003e(actor:Actor {delpending: false})-[:FOR_USER]-\u003e(u:User)\nOPTIONAL MATCH (pd)-[copdc:PLAN_DEFINITION_TO_CLINOP_CONTACT]-\u003e(co:ClinOp {deltimestamp: 0})-[:FOR_USER]-\u003e(cou:User)\nWITH sid, s,\n  collect(DISTINCT CASE\n    WHEN pdc IS NOT NULL AND actor IS NOT NULL AND (u IS NULL OR u.status \u003c\u003e $deleted_status) THEN {\n    t: pdc.type,\n    p: coalesce(pdc.isPrimary, false),\n    e: coalesce(u.email, \"\")\n  } END) AS actorContactRows,\n  collect(DISTINCT CASE\n    WHEN copdc IS NOT NULL AND co IS NOT NULL AND (cou IS NULL OR cou.status \u003c\u003e $deleted_status) THEN {\n    t: copdc.type,\n    p: coalesce(copdc.isPrimary, false),\n    e: coalesce(cou.email, \"\")\n  } END) AS clinopContactRows\nWITH sid, s, actorContactRows + clinopContactRows AS pdContactRowsRaw\nWITH sid, s,\n  [row IN pdContactRowsRaw WHERE row IS NOT NULL AND row.t IS NOT NULL AND row.e IS NOT NULL AND row.e \u003c\u003e \"\"] AS pd_rows\nRETURN sid AS site_id, coalesce(s.name, \"\") AS site_name, pd_rows\n",
  "queryParameters": "{deleted_status: \u0027Deleted\u0027, site_ids: [\u0027a6259678-9d0f-4311-8051-d1dca2333297\u0027], study_id: \u00270a62f219-a803-482f-8973-ab67b1a3baf7\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.429Z",
  "transactionId": 1753587.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942119",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027d74db13c-677a-4fd3-89f6-02349b34abfb\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.429Z",
  "transactionId": 12137620.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B774BFC",
  "id": "13457728",
  "pageFaults": 0.0,
  "pageHits": 414.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (instance:WorkPlanInstance{tildaid:\"5ca8bb00-38a6-4d01-b31b-20cbe6b1a878\"})-[:WORKPLAN_TO_SITE]-\u003e(site:Site)\n\t\tRETURN site.tildaid as siteId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.422Z",
  "transactionId": 1753586.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "682A7B96",
  "id": "13457727",
  "pageFaults": 0.0,
  "pageHits": 329.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg{tildaid:\"37e5546c-d37f-4d97-a4ac-f5ebcc616248\"})-[:WORKPLAN_CFG_TO_STUDY]-\u003e(study:Study)\n\t\tRETURN study.tildaid as studyId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.416Z",
  "transactionId": 1753585.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942117",
  "pageFaults": 0.0,
  "pageHits": 9.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027d74db13c-677a-4fd3-89f6-02349b34abfb\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.416Z",
  "transactionId": 12137619.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 19512.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "3832EC22",
  "id": "13457725",
  "pageFaults": 0.0,
  "pageHits": 36.0,
  "planning": 0.0,
  "query": "\nUNWIND $site_ids AS sid\nOPTIONAL MATCH (s:Site {tildaid: sid, delpending: false})\nOPTIONAL MATCH (s)\u003c-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]-\u003e(st:Study {tildaid: $study_id, delpending: false})\nOPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]-\u003e(actor:Actor {delpending: false})-[:FOR_USER]-\u003e(u:User)\nOPTIONAL MATCH (pd)-[copdc:PLAN_DEFINITION_TO_CLINOP_CONTACT]-\u003e(co:ClinOp {deltimestamp: 0})-[:FOR_USER]-\u003e(cou:User)\nWITH sid, s,\n  collect(DISTINCT CASE\n    WHEN pdc IS NOT NULL AND actor IS NOT NULL AND (u IS NULL OR u.status \u003c\u003e $deleted_status) THEN {\n    t: pdc.type,\n    p: coalesce(pdc.isPrimary, false),\n    e: coalesce(u.email, \"\")\n  } END) AS actorContactRows,\n  collect(DISTINCT CASE\n    WHEN copdc IS NOT NULL AND co IS NOT NULL AND (cou IS NULL OR cou.status \u003c\u003e $deleted_status) THEN {\n    t: copdc.type,\n    p: coalesce(copdc.isPrimary, false),\n    e: coalesce(cou.email, \"\")\n  } END) AS clinopContactRows\nWITH sid, s, actorContactRows + clinopContactRows AS pdContactRowsRaw\nWITH sid, s,\n  [row IN pdContactRowsRaw WHERE row IS NOT NULL AND row.t IS NOT NULL AND row.e IS NOT NULL AND row.e \u003c\u003e \"\"] AS pd_rows\nRETURN sid AS site_id, coalesce(s.name, \"\") AS site_name, pd_rows\n",
  "queryParameters": "{deleted_status: \u0027Deleted\u0027, site_ids: [\u00279c081cd2-085b-4c6e-851e-abf432f301b4\u0027], study_id: \u00270a62f219-a803-482f-8973-ab67b1a3baf7\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.410Z",
  "transactionId": 1753584.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B774BFC",
  "id": "13457724",
  "pageFaults": 0.0,
  "pageHits": 414.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (instance:WorkPlanInstance{tildaid:\"e6c6652d-3cd8-4b9e-ac36-9df330acb222\"})-[:WORKPLAN_TO_SITE]-\u003e(site:Site)\n\t\tRETURN site.tildaid as siteId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.403Z",
  "transactionId": 1753583.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942114",
  "pageFaults": 0.0,
  "pageHits": 10.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027d74db13c-677a-4fd3-89f6-02349b34abfb\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.403Z",
  "transactionId": 12137618.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "682A7B96",
  "id": "13457722",
  "pageFaults": 0.0,
  "pageHits": 329.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg{tildaid:\"37e5546c-d37f-4d97-a4ac-f5ebcc616248\"})-[:WORKPLAN_CFG_TO_STUDY]-\u003e(study:Study)\n\t\tRETURN study.tildaid as studyId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.396Z",
  "transactionId": 1753582.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 19512.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "3832EC22",
  "id": "13457720",
  "pageFaults": 0.0,
  "pageHits": 28.0,
  "planning": 0.0,
  "query": "\nUNWIND $site_ids AS sid\nOPTIONAL MATCH (s:Site {tildaid: sid, delpending: false})\nOPTIONAL MATCH (s)\u003c-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]-\u003e(st:Study {tildaid: $study_id, delpending: false})\nOPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]-\u003e(actor:Actor {delpending: false})-[:FOR_USER]-\u003e(u:User)\nOPTIONAL MATCH (pd)-[copdc:PLAN_DEFINITION_TO_CLINOP_CONTACT]-\u003e(co:ClinOp {deltimestamp: 0})-[:FOR_USER]-\u003e(cou:User)\nWITH sid, s,\n  collect(DISTINCT CASE\n    WHEN pdc IS NOT NULL AND actor IS NOT NULL AND (u IS NULL OR u.status \u003c\u003e $deleted_status) THEN {\n    t: pdc.type,\n    p: coalesce(pdc.isPrimary, false),\n    e: coalesce(u.email, \"\")\n  } END) AS actorContactRows,\n  collect(DISTINCT CASE\n    WHEN copdc IS NOT NULL AND co IS NOT NULL AND (cou IS NULL OR cou.status \u003c\u003e $deleted_status) THEN {\n    t: copdc.type,\n    p: coalesce(copdc.isPrimary, false),\n    e: coalesce(cou.email, \"\")\n  } END) AS clinopContactRows\nWITH sid, s, actorContactRows + clinopContactRows AS pdContactRowsRaw\nWITH sid, s,\n  [row IN pdContactRowsRaw WHERE row IS NOT NULL AND row.t IS NOT NULL AND row.e IS NOT NULL AND row.e \u003c\u003e \"\"] AS pd_rows\nRETURN sid AS site_id, coalesce(s.name, \"\") AS site_name, pd_rows\n",
  "queryParameters": "{deleted_status: \u0027Deleted\u0027, site_ids: [\u0027a6259678-9d0f-4311-8051-d1dca2333297\u0027], study_id: \u00270a62f219-a803-482f-8973-ab67b1a3baf7\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.390Z",
  "transactionId": 1753581.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7656.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942113",
  "pageFaults": 0.0,
  "pageHits": 37.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 25, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u00278c5c5785-bead-41a8-8002-3d05b949c13d\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.389Z",
  "transactionId": 12137617.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942112",
  "pageFaults": 0.0,
  "pageHits": 20.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u00278c5c5785-bead-41a8-8002-3d05b949c13d\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.384Z",
  "transactionId": 12137617.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B774BFC",
  "id": "13457718",
  "pageFaults": 0.0,
  "pageHits": 414.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (instance:WorkPlanInstance{tildaid:\"3dde6deb-a932-4d03-8c71-ce3a8e26bef7\"})-[:WORKPLAN_TO_SITE]-\u003e(site:Site)\n\t\tRETURN site.tildaid as siteId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.384Z",
  "transactionId": 1753580.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "682A7B96",
  "id": "13457716",
  "pageFaults": 0.0,
  "pageHits": 329.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg{tildaid:\"a9f727b2-f56d-4267-b30f-8859577d46a9\"})-[:WORKPLAN_CFG_TO_STUDY]-\u003e(study:Study)\n\t\tRETURN study.tildaid as studyId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.377Z",
  "transactionId": 1753579.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E5CF3BBC",
  "id": "24942110",
  "pageFaults": 0.0,
  "pageHits": 6.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $wo})-[:WORK_ORDER_TO_ORGANIZATION]-\u003e(o:Organization)\n            RETURN COALESCE(o.reminderApprovalRequired, true) AS approval_required\n            ",
  "queryParameters": "{wo: \u00278c5c5785-bead-41a8-8002-3d05b949c13d\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.372Z",
  "transactionId": 12137616.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 19512.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "3832EC22",
  "id": "13457713",
  "pageFaults": 0.0,
  "pageHits": 36.0,
  "planning": 0.0,
  "query": "\nUNWIND $site_ids AS sid\nOPTIONAL MATCH (s:Site {tildaid: sid, delpending: false})\nOPTIONAL MATCH (s)\u003c-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]-\u003e(st:Study {tildaid: $study_id, delpending: false})\nOPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]-\u003e(actor:Actor {delpending: false})-[:FOR_USER]-\u003e(u:User)\nOPTIONAL MATCH (pd)-[copdc:PLAN_DEFINITION_TO_CLINOP_CONTACT]-\u003e(co:ClinOp {deltimestamp: 0})-[:FOR_USER]-\u003e(cou:User)\nWITH sid, s,\n  collect(DISTINCT CASE\n    WHEN pdc IS NOT NULL AND actor IS NOT NULL AND (u IS NULL OR u.status \u003c\u003e $deleted_status) THEN {\n    t: pdc.type,\n    p: coalesce(pdc.isPrimary, false),\n    e: coalesce(u.email, \"\")\n  } END) AS actorContactRows,\n  collect(DISTINCT CASE\n    WHEN copdc IS NOT NULL AND co IS NOT NULL AND (cou IS NULL OR cou.status \u003c\u003e $deleted_status) THEN {\n    t: copdc.type,\n    p: coalesce(copdc.isPrimary, false),\n    e: coalesce(cou.email, \"\")\n  } END) AS clinopContactRows\nWITH sid, s, actorContactRows + clinopContactRows AS pdContactRowsRaw\nWITH sid, s,\n  [row IN pdContactRowsRaw WHERE row IS NOT NULL AND row.t IS NOT NULL AND row.e IS NOT NULL AND row.e \u003c\u003e \"\"] AS pd_rows\nRETURN sid AS site_id, coalesce(s.name, \"\") AS site_name, pd_rows\n",
  "queryParameters": "{deleted_status: \u0027Deleted\u0027, site_ids: [\u00279c081cd2-085b-4c6e-851e-abf432f301b4\u0027], study_id: \u00270a62f219-a803-482f-8973-ab67b1a3baf7\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.371Z",
  "transactionId": 1753578.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B774BFC",
  "id": "13457712",
  "pageFaults": 0.0,
  "pageHits": 416.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (instance:WorkPlanInstance{tildaid:\"4102804a-71a2-48ef-8acf-e1d9a4321996\"})-[:WORKPLAN_TO_SITE]-\u003e(site:Site)\n\t\tRETURN site.tildaid as siteId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.364Z",
  "transactionId": 1753577.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7560.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942108",
  "pageFaults": 0.0,
  "pageHits": 37.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u00278c5c5785-bead-41a8-8002-3d05b949c13d\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.359Z",
  "transactionId": 12137615.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "682A7B96",
  "id": "13457710",
  "pageFaults": 0.0,
  "pageHits": 329.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg{tildaid:\"a9f727b2-f56d-4267-b30f-8859577d46a9\"})-[:WORKPLAN_CFG_TO_STUDY]-\u003e(study:Study)\n\t\tRETURN study.tildaid as studyId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.358Z",
  "transactionId": 1753576.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942107",
  "pageFaults": 0.0,
  "pageHits": 20.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u00278c5c5785-bead-41a8-8002-3d05b949c13d\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.353Z",
  "transactionId": 12137615.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 19512.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "3832EC22",
  "id": "13457707",
  "pageFaults": 0.0,
  "pageHits": 22.0,
  "planning": 0.0,
  "query": "\nUNWIND $site_ids AS sid\nOPTIONAL MATCH (s:Site {tildaid: sid, delpending: false})\nOPTIONAL MATCH (s)\u003c-[:PLAN_DEFINITION_TO_SITE]-(pd:DslPlanDefinition {delpending: false})-[:PLAN_DEFINITION_TO_STUDY]-\u003e(st:Study {tildaid: $study_id, delpending: false})\nOPTIONAL MATCH (pd)-[pdc:PLAN_DEFINITION_TO_CONTACT]-\u003e(actor:Actor {delpending: false})-[:FOR_USER]-\u003e(u:User)\nOPTIONAL MATCH (pd)-[copdc:PLAN_DEFINITION_TO_CLINOP_CONTACT]-\u003e(co:ClinOp {deltimestamp: 0})-[:FOR_USER]-\u003e(cou:User)\nWITH sid, s,\n  collect(DISTINCT CASE\n    WHEN pdc IS NOT NULL AND actor IS NOT NULL AND (u IS NULL OR u.status \u003c\u003e $deleted_status) THEN {\n    t: pdc.type,\n    p: coalesce(pdc.isPrimary, false),\n    e: coalesce(u.email, \"\")\n  } END) AS actorContactRows,\n  collect(DISTINCT CASE\n    WHEN copdc IS NOT NULL AND co IS NOT NULL AND (cou IS NULL OR cou.status \u003c\u003e $deleted_status) THEN {\n    t: copdc.type,\n    p: coalesce(copdc.isPrimary, false),\n    e: coalesce(cou.email, \"\")\n  } END) AS clinopContactRows\nWITH sid, s, actorContactRows + clinopContactRows AS pdContactRowsRaw\nWITH sid, s,\n  [row IN pdContactRowsRaw WHERE row IS NOT NULL AND row.t IS NOT NULL AND row.e IS NOT NULL AND row.e \u003c\u003e \"\"] AS pd_rows\nRETURN sid AS site_id, coalesce(s.name, \"\") AS site_name, pd_rows\n",
  "queryParameters": "{deleted_status: \u0027Deleted\u0027, site_ids: [\u0027cec6713e-0087-4942-91db-316352bbca2c\u0027], study_id: \u00275b971f19-ded8-4c5d-8649-5b2a96841d67\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.352Z",
  "transactionId": 1753575.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "9B774BFC",
  "id": "13457706",
  "pageFaults": 0.0,
  "pageHits": 415.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (instance:WorkPlanInstance{tildaid:\"4104335e-49f9-4396-a635-7a4724b2c2cf\"})-[:WORKPLAN_TO_SITE]-\u003e(site:Site)\n\t\tRETURN site.tildaid as siteId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.346Z",
  "transactionId": 1753574.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942106",
  "pageFaults": 0.0,
  "pageHits": 28.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u00278c5c5785-bead-41a8-8002-3d05b949c13d\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.342Z",
  "transactionId": 12137614.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "682A7B96",
  "id": "13457704",
  "pageFaults": 0.0,
  "pageHits": 329.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg{tildaid:\"0590e24b-65f6-4c37-b293-8899478c233a\"})-[:WORKPLAN_CFG_TO_STUDY]-\u003e(study:Study)\n\t\tRETURN study.tildaid as studyId\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.339Z",
  "transactionId": 1753573.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 336.0,
  "cpu": 7.0,
  "elapsedTimeMs": 7.0,
  "executionPlanCacheKeyHash": "C9113EA6",
  "id": "13457702",
  "pageFaults": 0.0,
  "pageHits": 7311.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]-\u003e(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]-\u003e(m:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]-\u003e(item:WorkplanInstanceMilestoneItem)\n\t\tWHERE item.itemType = \"Workorder\"\n\t\t  AND coalesce(item.workOrderActivationFailedAt, 0) \u003e 0\n\t\t  AND coalesce(item.workOrderActivationErrorCode, \"\") = \"NO_RECIPIENTS_FOR_SITE_CONTACT_CATEGORY\"\n\t\t  AND coalesce(item.workOrderCompletedAt, 0) = 0\n\t\t  AND coalesce(item.workOrderResolvedAt, 0) = 0\n\t\t  AND coalesce(item.skippedAt, 0) = 0 AND coalesce(item.notApplicableAt, 0) = 0\n\t\t  AND coalesce(item.workOrderId, \"\") \u003c\u003e \"\"\n\t\tRETURN cfg.tildaid AS cfgId, wp.tildaid AS instanceId, item.tildaid AS itemId,\n\t\t       item.workOrderId AS workOrderId, coalesce(item.itemConfig, \"\") AS itemConfig\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.333Z",
  "transactionId": 1753572.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942104",
  "pageFaults": 0.0,
  "pageHits": 12.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u00278c5c5785-bead-41a8-8002-3d05b949c13d\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.329Z",
  "transactionId": 12137613.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 336.0,
  "cpu": 7.0,
  "elapsedTimeMs": 7.0,
  "executionPlanCacheKeyHash": "32028411",
  "id": "13457699",
  "pageFaults": 0.0,
  "pageHits": 7544.0,
  "planning": 0.0,
  "query": "\n\t\tMATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]-\u003e(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]-\u003e(item:WorkplanInstanceMilestoneItem)\n\t\tWHERE item.itemType = \"Workorder\"\n\t\t  AND wp.state \u003c\u003e \"archived\"\n\t\t  AND coalesce(item.workOrderId, \"\") \u003c\u003e \"\"\n\t\t  AND coalesce(item.activationPending, false) = true\n\t\t  AND coalesce(item.activationEligible, false) = true\n\t\t  AND coalesce(item.activateRequestedAt, 0) = 0\n\t\tRETURN item.tildaid AS id\n\t\tLIMIT 80\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tGo Driver/5.20.0\t\tclient/10.129.4.159:49136\tserver/10.173.0.201:7687\u003e",
  "timestamp": "2026-07-27T01:13:18.321Z",
  "transactionId": 1753571.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7656.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942103",
  "pageFaults": 0.0,
  "pageHits": 53.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 25, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u002727504fe1-a00e-459f-af03-ba243eb31670\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.317Z",
  "transactionId": 12137612.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942101",
  "pageFaults": 0.0,
  "pageHits": 28.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u002727504fe1-a00e-459f-af03-ba243eb31670\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.311Z",
  "transactionId": 12137612.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 102656.0,
  "cpu": 4.0,
  "elapsedTimeMs": 4.0,
  "executionPlanCacheKeyHash": "5CC92BFF",
  "id": "24942100",
  "pageFaults": 0.0,
  "pageHits": 2298.0,
  "planning": 0.0,
  "query": "\n\t\tRETURN EXISTS {\n\t\t\tMATCH (inst:WorkPlanInstance)\n\t\t\tWHERE coalesce(inst.progressSummariesPending, false) = true\n\t\t} AS progressPending,\n\t\t       EXISTS {\n\t\t           MATCH (item:WorkplanInstanceMilestoneItem)\n\t\t           WHERE item.itemType = \"Workorder\"\n\t\t             AND coalesce(item.workOrderId, \"\") \u003c\u003e \"\"\n\t\t             AND coalesce(item.activationPending, false) = true\n\t\t             AND coalesce(item.activationEligible, false) = true\n\t\t             AND coalesce(item.activateRequestedAt, 0) = 0\n\t\t       } AS activationPending,\n\t\t       EXISTS {\n\t\t           MATCH (cfg:WorkplanCfg)\n\t\t           WHERE coalesce(cfg.workOrderEmailAutoSendTransitionPending, false) = true\n\t\t       } AS autosendTransition,\n\t\t       EXISTS {\n\t\t           MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]-\u003e(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]-\u003e(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]-\u003e(item:WorkplanInstanceMilestoneItem)\n\t\t           WHERE item.itemType = \"Workorder\"\n\t\t             AND coalesce(item.workOrderActivationFailedAt, 0) \u003e 0\n\t\t             AND coalesce(item.workOrderActivationErrorCode, \"\") = \"NO_RECIPIENTS_FOR_SITE_CONTACT_CATEGORY\"\n\t\t             AND coalesce(item.workOrderCompletedAt, 0) = 0\n\t\t             AND coalesce(item.workOrderResolvedAt, 0) = 0\n\t\t             AND coalesce(item.skippedAt, 0) = 0\n\t\t             AND coalesce(item.notApplicableAt, 0) = 0\n\t\t             AND coalesce(item.workOrderId, \"\") \u003c\u003e \"\"\n\t\t       } AS recipientRetry,\n\t\t       EXISTS {\n\t\t           MATCH (wp2:WorkPlanInstance)\n\t\t           WHERE wp2.instanceReadyDeterminationState = \"pending\"\n\t\t       } AS readyDetermination\n\t",
  "queryParameters": "{}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:58524\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.307Z",
  "transactionId": 12137611.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 328.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E5CF3BBC",
  "id": "24942099",
  "pageFaults": 0.0,
  "pageHits": 28.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $wo})-[:WORK_ORDER_TO_ORGANIZATION]-\u003e(o:Organization)\n            RETURN COALESCE(o.reminderApprovalRequired, true) AS approval_required\n            ",
  "queryParameters": "{wo: \u002727504fe1-a00e-459f-af03-ba243eb31670\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.300Z",
  "transactionId": 12137610.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 7560.0,
  "cpu": 1.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942097",
  "pageFaults": 0.0,
  "pageHits": 53.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u002727504fe1-a00e-459f-af03-ba243eb31670\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.287Z",
  "transactionId": 12137609.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942096",
  "pageFaults": 0.0,
  "pageHits": 28.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u002727504fe1-a00e-459f-af03-ba243eb31670\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.282Z",
  "transactionId": 12137609.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942095",
  "pageFaults": 0.0,
  "pageHits": 34.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u002727504fe1-a00e-459f-af03-ba243eb31670\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.271Z",
  "transactionId": 12137608.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942093",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u002727504fe1-a00e-459f-af03-ba243eb31670\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.258Z",
  "transactionId": 12137607.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 828.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942092",
  "pageFaults": 0.0,
  "pageHits": 10.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027f42328f2-c28d-44dd-9ba7-0b43ac19af6d\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.246Z",
  "transactionId": 12137606.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942090",
  "pageFaults": 0.0,
  "pageHits": 23.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027f42328f2-c28d-44dd-9ba7-0b43ac19af6d\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.235Z",
  "transactionId": 12137605.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942089",
  "pageFaults": 0.0,
  "pageHits": 24.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027f42328f2-c28d-44dd-9ba7-0b43ac19af6d\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.229Z",
  "transactionId": 12137605.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942087",
  "pageFaults": 0.0,
  "pageHits": 44.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027f42328f2-c28d-44dd-9ba7-0b43ac19af6d\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.217Z",
  "transactionId": 12137604.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942086",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027f42328f2-c28d-44dd-9ba7-0b43ac19af6d\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.204Z",
  "transactionId": 12137603.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 776.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942084",
  "pageFaults": 0.0,
  "pageHits": 10.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027b26f2eda-ea91-4a98-b778-0a7db67a2b6a\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.191Z",
  "transactionId": 12137602.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942083",
  "pageFaults": 0.0,
  "pageHits": 6.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027b26f2eda-ea91-4a98-b778-0a7db67a2b6a\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.180Z",
  "transactionId": 12137601.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942082",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027b26f2eda-ea91-4a98-b778-0a7db67a2b6a\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.175Z",
  "transactionId": 12137601.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942080",
  "pageFaults": 0.0,
  "pageHits": 9.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027b26f2eda-ea91-4a98-b778-0a7db67a2b6a\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.162Z",
  "transactionId": 12137600.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942078",
  "pageFaults": 0.0,
  "pageHits": 8.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027b26f2eda-ea91-4a98-b778-0a7db67a2b6a\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.149Z",
  "transactionId": 12137599.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 828.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942077",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027a90625ed-5354-473f-8665-840a4b8ff106\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.135Z",
  "transactionId": 12137598.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942075",
  "pageFaults": 0.0,
  "pageHits": 9.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027a90625ed-5354-473f-8665-840a4b8ff106\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.122Z",
  "transactionId": 12137597.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942074",
  "pageFaults": 0.0,
  "pageHits": 10.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027a90625ed-5354-473f-8665-840a4b8ff106\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.117Z",
  "transactionId": 12137597.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942073",
  "pageFaults": 0.0,
  "pageHits": 12.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027a90625ed-5354-473f-8665-840a4b8ff106\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.105Z",
  "transactionId": 12137596.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942071",
  "pageFaults": 0.0,
  "pageHits": 10.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027a90625ed-5354-473f-8665-840a4b8ff106\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.092Z",
  "transactionId": 12137595.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 828.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942069",
  "pageFaults": 0.0,
  "pageHits": 10.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027e358167a-298a-4e2e-bd17-401ab034115e\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.078Z",
  "transactionId": 12137594.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942068",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027e358167a-298a-4e2e-bd17-401ab034115e\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.066Z",
  "transactionId": 12137593.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942067",
  "pageFaults": 0.0,
  "pageHits": 8.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027e358167a-298a-4e2e-bd17-401ab034115e\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.060Z",
  "transactionId": 12137593.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942065",
  "pageFaults": 0.0,
  "pageHits": 10.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027e358167a-298a-4e2e-bd17-401ab034115e\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.048Z",
  "transactionId": 12137592.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942064",
  "pageFaults": 0.0,
  "pageHits": 9.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027e358167a-298a-4e2e-bd17-401ab034115e\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.035Z",
  "transactionId": 12137591.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 776.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942060",
  "pageFaults": 0.0,
  "pageHits": 11.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027513b7315-882c-48fb-a126-ffc4e06834ec\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.022Z",
  "transactionId": 12137590.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 3272.0,
  "cpu": 0.0,
  "elapsedTimeMs": 1.0,
  "executionPlanCacheKeyHash": "2A13D7A9",
  "id": "24942057",
  "pageFaults": 0.0,
  "pageHits": 25.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        OPTIONAL MATCH (d:Document)\n        WHERE d.tildaid IN COALESCE(a.docIds, [])\n        WITH w, a, COLLECT(DISTINCT {tildaid: d.tildaid, fileName: d.fileName, contentType: d.contentType}) as documents\n        // Compute latest AI_MSG draft id per work order for gating REGENERATE\n        OPTIONAL MATCH (w)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(ai:WorkOrderActivity)\n        WHERE ai.activity_type = \u0027AI_MSG\u0027  // any status: a newer SENT/QUEUED must supersede an older FindingsChanged draft, else REGENERATE stays stuck\n        WITH w, a, documents,\n             max(coalesce(ai.updatedat, ai.createdat)) AS latest_any_ts,\n             collect({id: ai.tildaid, ts: coalesce(ai.updatedat, ai.createdat), status: ai.status, ignoreType: ai.ignoreType}) AS ai_msgs\n        WITH a, documents,\n             CASE\n               WHEN size(ai_msgs) = 0 THEN false\n               ELSE any(x IN ai_msgs WHERE x.id = a.tildaid AND x.ts = latest_any_ts)\n             END AS is_latest_draft\n        RETURN a,\n               CASE WHEN size(documents) \u003e 0 AND documents[0].tildaid IS NOT NULL THEN documents ELSE [] END AS documents,\n               is_latest_draft\n        ORDER BY a.createdat DESC\n        SKIP $skip\n        LIMIT $limit\n        ",
  "queryParameters": "{limit: 1, statuses: [\u0027DRAFT\u0027], skip: 0, work_order_id: \u0027513b7315-882c-48fb-a126-ffc4e06834ec\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.009Z",
  "transactionId": 12137589.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 488.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "FA66F084",
  "id": "24942055",
  "pageFaults": 0.0,
  "pageHits": 26.0,
  "planning": 0.0,
  "query": "\n        MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity)\n        WHERE 1=1 AND a.activity_type IN $activity_types AND a.status IN $statuses \n        RETURN count(a) as total\n        ",
  "queryParameters": "{statuses: [\u0027DRAFT\u0027], work_order_id: \u0027513b7315-882c-48fb-a126-ffc4e06834ec\u0027, activity_types: [\u0027AI_MSG\u0027]}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:18.004Z",
  "transactionId": 12137589.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 928.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "4C51129A",
  "id": "24942054",
  "pageFaults": 0.0,
  "pageHits": 38.0,
  "planning": 0.0,
  "query": "\n        MATCH (wo:WorkOrder {tildaid: $wo_id})\n        OPTIONAL MATCH (wo)-[:WORK_ORDER_TO_ACTIVITY]-\u003e(a:WorkOrderActivity {activity_type: \u0027U_REPLY\u0027})\n        RETURN wo.createdat AS created_at, max(a.timestamp) AS latest_reply_ts\n        ",
  "queryParameters": "{wo_id: \u0027513b7315-882c-48fb-a126-ffc4e06834ec\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:17.992Z",
  "transactionId": 12137588.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 312.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "E0146DD7",
  "id": "24942051",
  "pageFaults": 0.0,
  "pageHits": 12.0,
  "planning": 0.0,
  "query": "MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n",
  "queryParameters": "{node_id: \u0027513b7315-882c-48fb-a126-ffc4e06834ec\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:17.980Z",
  "transactionId": 12137587.0,
  "waiting": 0.0
}

{
  "allocatedBytes": 776.0,
  "cpu": 0.0,
  "elapsedTimeMs": 0.0,
  "executionPlanCacheKeyHash": "23A43F51",
  "id": "24942047",
  "pageFaults": 0.0,
  "pageHits": 7.0,
  "planning": 0.0,
  "query": "\n            MATCH (w:WorkOrder {tildaid: $work_order_id})\u003c-[:FACT_TO_WORK_ORDER]-(f:Fact)\n            WHERE f.delpending = false\n            RETURN f\n            ORDER BY f.createdat ASC\n            ",
  "queryParameters": "{work_order_id: \u0027442a7419-9334-4479-aa7e-c607afaee462\u0027}",
  "runtime": "pipelined",
  "source": "bolt-session\tbolt\tneo4j-java/5.28.13-24cd0fecc64de123fd5711190246e8b0f1e16fd0\t\tclient/10.173.0.201:48790\tserver/10.173.0.8:7688\u003e",
  "timestamp": "2026-07-27T01:13:17.966Z",
  "transactionId": 12137586.0,
  "waiting": 0.0
}