Xray
daily rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 14 days▾
Ends now. Anything up to this cluster's 30-day retention.
Start and end times
Cancel
Interpreted in UTC (change it at the right of this bar). Earliest available: 2026-10-19 09:55:06.
› →|
updated 23h ago
Sample data. This database was generated by scripts/seed_dev_db.py — every service, deploy, person and figure on this page is synthetic. Names are sample.*@seed.invalid and image tags are prefixed SEED-. Nothing here happened.

Shared data paths 26

stored 23h ago all 26coupling through shared query shapes

Which services on automation read the same graph over the last 14d — the coupling that decides the blast radius of a schema change. ?Two services running the same query shape depend on the same labels, properties and indexes, whether or not they ever call each other. Change one and both are affected. A matrix rather than a node graph because at this size a force-directed graph is a hairball whose layout changes every render, while a matrix sorts meaningfully and lets you read one row across.

How to read this page — shared data paths

Two services that run the same query shape depend on the same labels, properties and indexes — whether or not they ever call each other. That is the coupling that decides the blast radius of a schema or index change.

a cell
How many query shapes the two services on that row and column both run. Darker is more. The diagonal is left empty because a service trivially shares everything with itself.
query shape
A statement with its literal values stripped out, identified by Neo4j's own plan-cache hash — so the same query with different ids counts once.
widest reach
Shapes ordered by how many services run them. These are the statements where a changed index or a renamed property hurts most at once.

What this page will not tell you

  • Who calls whom. This is not a call graph and cannot become one from stored data: nothing here carries both a trace id and a service name, so the edge "A called B" does not exist in the database. See docs/UPSTREAM-DATA.md.
  • Direction or dependency. A shared shape is symmetric — it says both services read the same thing, not that one depends on the other.
This is coupling through the data, not a call graph. Nothing stored here carries both a trace id and a service name, so an edge saying “A called B” cannot be drawn from the database — only from a collector that scans traces and stores the pairs. That is written up in docs/UPSTREAM-DATA.md. What is on this page is real and from stored data: services that read the same shapes.

Services × services, by shapes they both run

studiosvcstudiosvcexecsvcexecsvconboardingsvconboardingsvcdocsvcdocsvcworkplansvcworkplansvcvirtual-assistantvirtual-assistanttuskertuskerdocprocdocprocenrollsvcenrollsvcregsvcregsvcschedsvcschedsvctmfsynctmfsyncnotifsvcnotifsvcdashrsvcdashrsvcpatientsvcpatientsvcfinsvcfinsvcdata_monitordata_monitordashqldashqladvpsvcadvpsvcfeedsvcfeedsvcontologysvcontologysvcexportsvcexportsvcschema-migrateschema-migratechat-agentchat-agentrag-agentrag-agentappappstudiosvc ↔ execsvc: 145 shared shapesstudiosvc ↔ onboardingsvc: 157 shared shapesstudiosvc ↔ docsvc: 196 shared shapesstudiosvc ↔ workplansvc: 47 shared shapesstudiosvc ↔ tusker: 164 shared shapesstudiosvc ↔ docproc: 1 shared shapesstudiosvc ↔ enrollsvc: 143 shared shapesstudiosvc ↔ regsvc: 68 shared shapesstudiosvc ↔ schedsvc: 144 shared shapesstudiosvc ↔ notifsvc: 8 shared shapesstudiosvc ↔ patientsvc: 92 shared shapesstudiosvc ↔ finsvc: 32 shared shapesstudiosvc ↔ dashql: 142 shared shapesstudiosvc ↔ advpsvc: 8 shared shapesstudiosvc ↔ schema-migrate: 2 shared shapesexecsvc ↔ studiosvc: 145 shared shapesexecsvc ↔ onboardingsvc: 320 shared shapesexecsvc ↔ docsvc: 275 shared shapesexecsvc ↔ workplansvc: 60 shared shapesexecsvc ↔ tusker: 226 shared shapesexecsvc ↔ enrollsvc: 306 shared shapesexecsvc ↔ regsvc: 131 shared shapesexecsvc ↔ schedsvc: 169 shared shapesexecsvc ↔ notifsvc: 24 shared shapesexecsvc ↔ patientsvc: 101 shared shapesexecsvc ↔ finsvc: 66 shared shapesexecsvc ↔ dashql: 144 shared shapesexecsvc ↔ advpsvc: 11 shared shapesexecsvc ↔ schema-migrate: 2 shared shapesonboardingsvc ↔ studiosvc: 157 shared shapesonboardingsvc ↔ execsvc: 320 shared shapesonboardingsvc ↔ docsvc: 314 shared shapesonboardingsvc ↔ workplansvc: 49 shared shapesonboardingsvc ↔ tusker: 164 shared shapesonboardingsvc ↔ enrollsvc: 330 shared shapesonboardingsvc ↔ regsvc: 88 shared shapesonboardingsvc ↔ schedsvc: 169 shared shapesonboardingsvc ↔ notifsvc: 42 shared shapesonboardingsvc ↔ patientsvc: 123 shared shapesonboardingsvc ↔ finsvc: 56 shared shapesonboardingsvc ↔ dashql: 144 shared shapesonboardingsvc ↔ advpsvc: 11 shared shapesonboardingsvc ↔ schema-migrate: 3 shared shapesdocsvc ↔ studiosvc: 196 shared shapesdocsvc ↔ execsvc: 275 shared shapesdocsvc ↔ onboardingsvc: 314 shared shapesdocsvc ↔ workplansvc: 56 shared shapesdocsvc ↔ tusker: 190 shared shapesdocsvc ↔ enrollsvc: 228 shared shapesdocsvc ↔ regsvc: 116 shared shapesdocsvc ↔ schedsvc: 167 shared shapesdocsvc ↔ notifsvc: 22 shared shapesdocsvc ↔ dashrsvc: 1 shared shapesdocsvc ↔ patientsvc: 120 shared shapesdocsvc ↔ finsvc: 58 shared shapesdocsvc ↔ dashql: 152 shared shapesdocsvc ↔ advpsvc: 23 shared shapesdocsvc ↔ schema-migrate: 1 shared shapesworkplansvc ↔ studiosvc: 47 shared shapesworkplansvc ↔ execsvc: 60 shared shapesworkplansvc ↔ onboardingsvc: 49 shared shapesworkplansvc ↔ docsvc: 56 shared shapesworkplansvc ↔ tusker: 61 shared shapesworkplansvc ↔ enrollsvc: 55 shared shapesworkplansvc ↔ regsvc: 33 shared shapesworkplansvc ↔ schedsvc: 46 shared shapesworkplansvc ↔ notifsvc: 8 shared shapesworkplansvc ↔ patientsvc: 40 shared shapesworkplansvc ↔ finsvc: 19 shared shapesworkplansvc ↔ dashql: 41 shared shapesworkplansvc ↔ advpsvc: 7 shared shapesworkplansvc ↔ schema-migrate: 2 shared shapesvirtual-assistant ↔ docproc: 75 shared shapesvirtual-assistant ↔ tmfsync: 7 shared shapesvirtual-assistant ↔ data_monitor: 3 shared shapesvirtual-assistant ↔ feedsvc: 62 shared shapesvirtual-assistant ↔ ontologysvc: 29 shared shapesvirtual-assistant ↔ exportsvc: 7 shared shapesvirtual-assistant ↔ chat-agent: 7 shared shapesvirtual-assistant ↔ rag-agent: 8 shared shapestusker ↔ studiosvc: 164 shared shapestusker ↔ execsvc: 226 shared shapestusker ↔ onboardingsvc: 164 shared shapestusker ↔ docsvc: 190 shared shapestusker ↔ workplansvc: 61 shared shapestusker ↔ docproc: 1 shared shapestusker ↔ enrollsvc: 130 shared shapestusker ↔ regsvc: 113 shared shapestusker ↔ schedsvc: 169 shared shapestusker ↔ notifsvc: 10 shared shapestusker ↔ patientsvc: 93 shared shapestusker ↔ finsvc: 44 shared shapestusker ↔ dashql: 173 shared shapestusker ↔ advpsvc: 10 shared shapestusker ↔ schema-migrate: 4 shared shapesdocproc ↔ studiosvc: 1 shared shapesdocproc ↔ virtual-assistant: 75 shared shapesdocproc ↔ tusker: 1 shared shapesdocproc ↔ regsvc: 1 shared shapesdocproc ↔ tmfsync: 3 shared shapesdocproc ↔ data_monitor: 3 shared shapesdocproc ↔ feedsvc: 51 shared shapesdocproc ↔ ontologysvc: 23 shared shapesdocproc ↔ exportsvc: 4 shared shapesdocproc ↔ chat-agent: 4 shared shapesdocproc ↔ rag-agent: 7 shared shapesenrollsvc ↔ studiosvc: 143 shared shapesenrollsvc ↔ execsvc: 306 shared shapesenrollsvc ↔ onboardingsvc: 330 shared shapesenrollsvc ↔ docsvc: 228 shared shapesenrollsvc ↔ workplansvc: 55 shared shapesenrollsvc ↔ tusker: 130 shared shapesenrollsvc ↔ regsvc: 79 shared shapesenrollsvc ↔ schedsvc: 128 shared shapesenrollsvc ↔ notifsvc: 36 shared shapesenrollsvc ↔ patientsvc: 125 shared shapesenrollsvc ↔ finsvc: 65 shared shapesenrollsvc ↔ dashql: 118 shared shapesenrollsvc ↔ advpsvc: 34 shared shapesenrollsvc ↔ schema-migrate: 2 shared shapesregsvc ↔ studiosvc: 68 shared shapesregsvc ↔ execsvc: 131 shared shapesregsvc ↔ onboardingsvc: 88 shared shapesregsvc ↔ docsvc: 116 shared shapesregsvc ↔ workplansvc: 33 shared shapesregsvc ↔ tusker: 113 shared shapesregsvc ↔ docproc: 1 shared shapesregsvc ↔ enrollsvc: 79 shared shapesregsvc ↔ schedsvc: 95 shared shapesregsvc ↔ notifsvc: 10 shared shapesregsvc ↔ patientsvc: 65 shared shapesregsvc ↔ finsvc: 51 shared shapesregsvc ↔ dashql: 77 shared shapesregsvc ↔ advpsvc: 12 shared shapesregsvc ↔ schema-migrate: 3 shared shapesschedsvc ↔ studiosvc: 144 shared shapesschedsvc ↔ execsvc: 169 shared shapesschedsvc ↔ onboardingsvc: 169 shared shapesschedsvc ↔ docsvc: 167 shared shapesschedsvc ↔ workplansvc: 46 shared shapesschedsvc ↔ tusker: 169 shared shapesschedsvc ↔ enrollsvc: 128 shared shapesschedsvc ↔ regsvc: 95 shared shapesschedsvc ↔ notifsvc: 71 shared shapesschedsvc ↔ patientsvc: 98 shared shapesschedsvc ↔ finsvc: 93 shared shapesschedsvc ↔ dashql: 160 shared shapesschedsvc ↔ advpsvc: 8 shared shapesschedsvc ↔ schema-migrate: 2 shared shapestmfsync ↔ virtual-assistant: 7 shared shapestmfsync ↔ docproc: 3 shared shapestmfsync ↔ data_monitor: 3 shared shapestmfsync ↔ feedsvc: 5 shared shapestmfsync ↔ ontologysvc: 7 shared shapestmfsync ↔ exportsvc: 7 shared shapestmfsync ↔ chat-agent: 6 shared shapestmfsync ↔ rag-agent: 9 shared shapesnotifsvc ↔ studiosvc: 8 shared shapesnotifsvc ↔ execsvc: 24 shared shapesnotifsvc ↔ onboardingsvc: 42 shared shapesnotifsvc ↔ docsvc: 22 shared shapesnotifsvc ↔ workplansvc: 8 shared shapesnotifsvc ↔ tusker: 10 shared shapesnotifsvc ↔ enrollsvc: 36 shared shapesnotifsvc ↔ regsvc: 10 shared shapesnotifsvc ↔ schedsvc: 71 shared shapesnotifsvc ↔ patientsvc: 18 shared shapesnotifsvc ↔ finsvc: 12 shared shapesnotifsvc ↔ dashql: 4 shared shapesnotifsvc ↔ advpsvc: 32 shared shapesnotifsvc ↔ schema-migrate: 3 shared shapesdashrsvc ↔ docsvc: 1 shared shapespatientsvc ↔ studiosvc: 92 shared shapespatientsvc ↔ execsvc: 101 shared shapespatientsvc ↔ onboardingsvc: 123 shared shapespatientsvc ↔ docsvc: 120 shared shapespatientsvc ↔ workplansvc: 40 shared shapespatientsvc ↔ tusker: 93 shared shapespatientsvc ↔ enrollsvc: 125 shared shapespatientsvc ↔ regsvc: 65 shared shapespatientsvc ↔ schedsvc: 98 shared shapespatientsvc ↔ notifsvc: 18 shared shapespatientsvc ↔ finsvc: 42 shared shapespatientsvc ↔ dashql: 88 shared shapespatientsvc ↔ advpsvc: 13 shared shapespatientsvc ↔ schema-migrate: 4 shared shapesfinsvc ↔ studiosvc: 32 shared shapesfinsvc ↔ execsvc: 66 shared shapesfinsvc ↔ onboardingsvc: 56 shared shapesfinsvc ↔ docsvc: 58 shared shapesfinsvc ↔ workplansvc: 19 shared shapesfinsvc ↔ tusker: 44 shared shapesfinsvc ↔ enrollsvc: 65 shared shapesfinsvc ↔ regsvc: 51 shared shapesfinsvc ↔ schedsvc: 93 shared shapesfinsvc ↔ notifsvc: 12 shared shapesfinsvc ↔ patientsvc: 42 shared shapesfinsvc ↔ dashql: 33 shared shapesfinsvc ↔ advpsvc: 10 shared shapesfinsvc ↔ schema-migrate: 6 shared shapesdata_monitor ↔ virtual-assistant: 3 shared shapesdata_monitor ↔ docproc: 3 shared shapesdata_monitor ↔ tmfsync: 3 shared shapesdata_monitor ↔ feedsvc: 2 shared shapesdata_monitor ↔ ontologysvc: 3 shared shapesdata_monitor ↔ exportsvc: 4 shared shapesdata_monitor ↔ chat-agent: 3 shared shapesdata_monitor ↔ rag-agent: 4 shared shapesdashql ↔ studiosvc: 142 shared shapesdashql ↔ execsvc: 144 shared shapesdashql ↔ onboardingsvc: 144 shared shapesdashql ↔ docsvc: 152 shared shapesdashql ↔ workplansvc: 41 shared shapesdashql ↔ tusker: 173 shared shapesdashql ↔ enrollsvc: 118 shared shapesdashql ↔ regsvc: 77 shared shapesdashql ↔ schedsvc: 160 shared shapesdashql ↔ notifsvc: 4 shared shapesdashql ↔ patientsvc: 88 shared shapesdashql ↔ finsvc: 33 shared shapesdashql ↔ advpsvc: 5 shared shapesdashql ↔ schema-migrate: 2 shared shapesadvpsvc ↔ studiosvc: 8 shared shapesadvpsvc ↔ execsvc: 11 shared shapesadvpsvc ↔ onboardingsvc: 11 shared shapesadvpsvc ↔ docsvc: 23 shared shapesadvpsvc ↔ workplansvc: 7 shared shapesadvpsvc ↔ tusker: 10 shared shapesadvpsvc ↔ enrollsvc: 34 shared shapesadvpsvc ↔ regsvc: 12 shared shapesadvpsvc ↔ schedsvc: 8 shared shapesadvpsvc ↔ notifsvc: 32 shared shapesadvpsvc ↔ patientsvc: 13 shared shapesadvpsvc ↔ finsvc: 10 shared shapesadvpsvc ↔ dashql: 5 shared shapesadvpsvc ↔ schema-migrate: 5 shared shapesfeedsvc ↔ virtual-assistant: 62 shared shapesfeedsvc ↔ docproc: 51 shared shapesfeedsvc ↔ tmfsync: 5 shared shapesfeedsvc ↔ data_monitor: 2 shared shapesfeedsvc ↔ ontologysvc: 23 shared shapesfeedsvc ↔ exportsvc: 6 shared shapesfeedsvc ↔ chat-agent: 3 shared shapesfeedsvc ↔ rag-agent: 4 shared shapesontologysvc ↔ virtual-assistant: 29 shared shapesontologysvc ↔ docproc: 23 shared shapesontologysvc ↔ tmfsync: 7 shared shapesontologysvc ↔ data_monitor: 3 shared shapesontologysvc ↔ feedsvc: 23 shared shapesontologysvc ↔ exportsvc: 6 shared shapesontologysvc ↔ chat-agent: 5 shared shapesontologysvc ↔ rag-agent: 9 shared shapesexportsvc ↔ virtual-assistant: 7 shared shapesexportsvc ↔ docproc: 4 shared shapesexportsvc ↔ tmfsync: 7 shared shapesexportsvc ↔ data_monitor: 4 shared shapesexportsvc ↔ feedsvc: 6 shared shapesexportsvc ↔ ontologysvc: 6 shared shapesexportsvc ↔ chat-agent: 7 shared shapesexportsvc ↔ rag-agent: 8 shared shapesschema-migrate ↔ studiosvc: 2 shared shapesschema-migrate ↔ execsvc: 2 shared shapesschema-migrate ↔ onboardingsvc: 3 shared shapesschema-migrate ↔ docsvc: 1 shared shapesschema-migrate ↔ workplansvc: 2 shared shapesschema-migrate ↔ tusker: 4 shared shapesschema-migrate ↔ enrollsvc: 2 shared shapesschema-migrate ↔ regsvc: 3 shared shapesschema-migrate ↔ schedsvc: 2 shared shapesschema-migrate ↔ notifsvc: 3 shared shapesschema-migrate ↔ patientsvc: 4 shared shapesschema-migrate ↔ finsvc: 6 shared shapesschema-migrate ↔ dashql: 2 shared shapesschema-migrate ↔ advpsvc: 5 shared shapeschat-agent ↔ virtual-assistant: 7 shared shapeschat-agent ↔ docproc: 4 shared shapeschat-agent ↔ tmfsync: 6 shared shapeschat-agent ↔ data_monitor: 3 shared shapeschat-agent ↔ feedsvc: 3 shared shapeschat-agent ↔ ontologysvc: 5 shared shapeschat-agent ↔ exportsvc: 7 shared shapeschat-agent ↔ rag-agent: 8 shared shapesrag-agent ↔ virtual-assistant: 8 shared shapesrag-agent ↔ docproc: 7 shared shapesrag-agent ↔ tmfsync: 9 shared shapesrag-agent ↔ data_monitor: 4 shared shapesrag-agent ↔ feedsvc: 4 shared shapesrag-agent ↔ ontologysvc: 9 shared shapesrag-agent ↔ exportsvc: 8 shared shapesrag-agent ↔ chat-agent: 8 shared shapes

Shapes with the widest reach

A statement many services run is the one where an index change, a renamed property or a slow plan hurts most at once. These are ordered by how many services execute them.

Query shapes ordered by how many services execute them
Services Who runs it Statement
13 advpsvc, docsvc, enrollsvc, execsvc, finsvc, notifsvc, onboardingsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
SHOW INDEXES YIELD name, labelsOrTypes, properties, type, entityType WHERE labelsOrTypes IS NOT NULL RETURN name, labelsOrTypes, properties, type, entityType
SHOW INDEXES YIELD name, labelsOrTypes, properties, type, entityType WHERE labelsOrTypes IS NOT NULL RETURN name, labelsOrTypes, properties, type, entityType
13 advpsvc, docsvc, enrollsvc, execsvc, finsvc, notifsvc, onboardingsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
SHOW CONSTRAINTS YIELD name, labelsOrTypes, properties, type, entityType RETURN name, labelsOrTypes, properties, type, entityType
SHOW CONSTRAINTS YIELD name, labelsOrTypes, properties, type, entityType RETURN name, labelsOrTypes, properties, type, entityType
13 advpsvc, docsvc, enrollsvc, execsvc, finsvc, notifsvc, onboardingsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
SHOW INDEXES YIELD name, labelsOrTypes, properties, type, entityType WHERE labelsOrTypes IS NOT NULL RETURN name, labelsOrTypes, properties, type, entityType
SHOW INDEXES YIELD name, labelsOrTypes, properties, type, entityType WHERE labelsOrTypes IS NOT NULL RETURN name, labelsOrTypes, properties, type, entityType
13 advpsvc, docsvc, enrollsvc, execsvc, finsvc, notifsvc, onboardingsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
SHOW CONSTRAINTS YIELD name, labelsOrTypes, properties, type, entityType RETURN name, labelsOrTypes, properties, type, entityType
SHOW CONSTRAINTS YIELD name, labelsOrTypes, properties, type, entityType RETURN name, labelsOrTypes, properties, type, entityType
13 advpsvc, dashql, docsvc, enrollsvc, execsvc, notifsvc, onboardingsvc, patientsvc, regsvc, schema-migrate, studiosvc, tusker, workplansvc
MATCH (p:Policy)-[:IS_ASSIGNED_TO]->(r:Role) WHERE coalesce(p.state, ?) IN [?, ?] OPTIONAL MATCH (r)<-[:MIMICS]-(m:Role) OPTIONAL MATCH (p)-[:APPLICABLE_IN]->(s:Scope{version:?}) // Both names go through one column: apoc.text.join takes a …
MATCH (p:Policy)-[:IS_ASSIGNED_TO]->(r:Role) WHERE coalesce(p.state, ?) IN [?, ?] OPTIONAL MATCH (r)<-[:MIMICS]-(m:Role) OPTIONAL MATCH (p)-[:APPLICABLE_IN]->(s:Scope{version:?}) // Both names go through one column: apoc.text.join takes a list of strings, // and concatenating two collected lists does not type-check as one. UNWIND [r.name, m.name] as roleName WITH p, s, apoc.text.join(collect(DISTINCT roleName), ?) as roleList return apoc.create.vNode([?], { name: p.name, description: p.description, roleList: roleList, objectTypeList: p.objectTypeList, allowedOps: p.allowedOps, scope: s.name})
12 advpsvc, dashql, enrollsvc, execsvc, finsvc, notifsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
MATCH (p:Policy)-[:IS_ASSIGNED_TO]->(r:Role) WHERE coalesce(p.state, ?) IN [?, ?] OPTIONAL MATCH (r)<-[:MIMICS]-(m:Role) OPTIONAL MATCH (p)-[:APPLICABLE_IN]->(s:Scope{version:?}) // Both names go through one column: apoc.text.join takes a …
MATCH (p:Policy)-[:IS_ASSIGNED_TO]->(r:Role) WHERE coalesce(p.state, ?) IN [?, ?] OPTIONAL MATCH (r)<-[:MIMICS]-(m:Role) OPTIONAL MATCH (p)-[:APPLICABLE_IN]->(s:Scope{version:?}) // Both names go through one column: apoc.text.join takes a list of strings, // and concatenating two collected lists does not type-check as one. UNWIND [r.name, m.name] as roleName WITH p, s, apoc.text.join(collect(DISTINCT roleName), ?) as roleList return apoc.create.vNode([?], { name: p.name, description: p.description, roleList: roleList, objectTypeList: p.objectTypeList, allowedOps: p.allowedOps, scope: s.name})
12 dashql, docsvc, enrollsvc, execsvc, finsvc, onboardingsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpe…
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpending:false, alias:$orgAlias}) // A deactivated (Inactive) org actor is not a membership (ENG-?). OPTIONAL MATCH (currentUser)-[:FOR_USER]-(orgActor:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(targetOrg) WHERE coalesce(orgActor.state, ?) <> ? OPTIONAL MATCH (currentUser)-[supports:SUPPORTS_ORG]-(targetOrg) WITH *, false AS repOf // Evaluated only for non-members; members are decided by orgActor alone. WITH *, CASE WHEN orgActor IS NULL THEN EXISTS { MATCH (currentUser)<-[:FOR_USER]-(da:Actor{delpending:false})<-[:STUDY_TO_DELEGATED_ACTOR]-(st:Study{delpending:false})-[:STUDY_TO_ORG]->(targetOrg), (da)-[:APPOINTED_AS]->(dr:Role)<-[:APPOINTED_AS]-(sa:Actor{delpending:false}), (da)-[:DELEGATED_FROM]->(sa)<-[:ORGANIZATION_TO_ACTOR]-(:Organization{alias:$tildaScaleAlias}) WHERE st.srcorgid = targetOrg.tildaid AND da.state <> ? AND sa.state <> ? AND $orgDelegatedTag IN apoc.text.split(coalesce(dr.tags, ?), ?) } ELSE false END as delegated RETURN CASE WHEN orgActor is not null THEN currentUser WHEN delegated THEN currentUser WHEN repOf THEN currentUser WHEN supports is not null THEN coalesce(supportUser, currentUser) ELSE currentUser END as user, CASE WHEN orgActor is not null OR delegated OR repOf OR supports is not null THEN targetOrg ELSE null END as org, currentUser as tokenUser
12 dashql, docsvc, enrollsvc, execsvc, finsvc, onboardingsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpe…
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpending:false, alias:$orgAlias}) // A deactivated (Inactive) org actor is not a membership (ENG-?). OPTIONAL MATCH (currentUser)-[:FOR_USER]-(orgActor:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(targetOrg) WHERE coalesce(orgActor.state, ?) <> ? OPTIONAL MATCH (currentUser)-[supports:SUPPORTS_ORG]-(targetOrg) WITH *, false AS repOf // Evaluated only for non-members; members are decided by orgActor alone. WITH *, CASE WHEN orgActor IS NULL THEN EXISTS { MATCH (currentUser)<-[:FOR_USER]-(da:Actor{delpending:false})<-[:STUDY_TO_DELEGATED_ACTOR]-(st:Study{delpending:false})-[:STUDY_TO_ORG]->(targetOrg), (da)-[:APPOINTED_AS]->(dr:Role)<-[:APPOINTED_AS]-(sa:Actor{delpending:false}), (da)-[:DELEGATED_FROM]->(sa)<-[:ORGANIZATION_TO_ACTOR]-(:Organization{alias:$tildaScaleAlias}) WHERE st.srcorgid = targetOrg.tildaid AND da.state <> ? AND sa.state <> ? AND $orgDelegatedTag IN apoc.text.split(coalesce(dr.tags, ?), ?) } ELSE false END as delegated RETURN CASE WHEN orgActor is not null THEN currentUser WHEN delegated THEN currentUser WHEN repOf THEN currentUser WHEN supports is not null THEN coalesce(supportUser, currentUser) ELSE currentUser END as user, CASE WHEN orgActor is not null OR delegated OR repOf OR supports is not null THEN targetOrg ELSE null END as org, currentUser as tokenUser
12 dashql, docsvc, enrollsvc, execsvc, finsvc, onboardingsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpe…
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpending:false, alias:$orgAlias}) // A deactivated (Inactive) org actor is not a membership (ENG-?). OPTIONAL MATCH (currentUser)-[:FOR_USER]-(orgActor:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(targetOrg) WHERE coalesce(orgActor.state, ?) <> ? OPTIONAL MATCH (currentUser)-[supports:SUPPORTS_ORG]-(targetOrg) WITH *, false AS repOf // Evaluated only for non-members; members are decided by orgActor alone. WITH *, CASE WHEN orgActor IS NULL THEN EXISTS { MATCH (currentUser)<-[:FOR_USER]-(da:Actor{delpending:false})<-[:STUDY_TO_DELEGATED_ACTOR]-(st:Study{delpending:false})-[:STUDY_TO_ORG]->(targetOrg), (da)-[:APPOINTED_AS]->(dr:Role)<-[:APPOINTED_AS]-(sa:Actor{delpending:false}), (da)-[:DELEGATED_FROM]->(sa)<-[:ORGANIZATION_TO_ACTOR]-(:Organization{alias:$tildaScaleAlias}) WHERE st.srcorgid = targetOrg.tildaid AND da.state <> ? AND sa.state <> ? AND $orgDelegatedTag IN apoc.text.split(coalesce(dr.tags, ?), ?) } ELSE false END as delegated RETURN CASE WHEN orgActor is not null THEN currentUser WHEN delegated THEN currentUser WHEN repOf THEN currentUser WHEN supports is not null THEN coalesce(supportUser, currentUser) ELSE currentUser END as user, CASE WHEN orgActor is not null OR delegated OR repOf OR supports is not null THEN targetOrg ELSE null END as org, currentUser as tokenUser
12 dashql, docsvc, enrollsvc, execsvc, finsvc, onboardingsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpe…
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpending:false, alias:$orgAlias}) // A deactivated (Inactive) org actor is not a membership (ENG-?). OPTIONAL MATCH (currentUser)-[:FOR_USER]-(orgActor:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(targetOrg) WHERE coalesce(orgActor.state, ?) <> ? OPTIONAL MATCH (currentUser)-[supports:SUPPORTS_ORG]-(targetOrg) WITH *, false AS repOf // Evaluated only for non-members; members are decided by orgActor alone. WITH *, CASE WHEN orgActor IS NULL THEN EXISTS { MATCH (currentUser)<-[:FOR_USER]-(da:Actor{delpending:false})<-[:STUDY_TO_DELEGATED_ACTOR]-(st:Study{delpending:false})-[:STUDY_TO_ORG]->(targetOrg), (da)-[:APPOINTED_AS]->(dr:Role)<-[:APPOINTED_AS]-(sa:Actor{delpending:false}), (da)-[:DELEGATED_FROM]->(sa)<-[:ORGANIZATION_TO_ACTOR]-(:Organization{alias:$tildaScaleAlias}) WHERE st.srcorgid = targetOrg.tildaid AND da.state <> ? AND sa.state <> ? AND $orgDelegatedTag IN apoc.text.split(coalesce(dr.tags, ?), ?) } ELSE false END as delegated RETURN CASE WHEN orgActor is not null THEN currentUser WHEN delegated THEN currentUser WHEN repOf THEN currentUser WHEN supports is not null THEN coalesce(supportUser, currentUser) ELSE currentUser END as user, CASE WHEN orgActor is not null OR delegated OR repOf OR supports is not null THEN targetOrg ELSE null END as org, currentUser as tokenUser
12 dashql, docsvc, enrollsvc, execsvc, finsvc, onboardingsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpe…
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpending:false, alias:$orgAlias}) // A deactivated (Inactive) org actor is not a membership (ENG-?). OPTIONAL MATCH (currentUser)-[:FOR_USER]-(orgActor:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(targetOrg) WHERE coalesce(orgActor.state, ?) <> ? OPTIONAL MATCH (currentUser)-[supports:SUPPORTS_ORG]-(targetOrg) WITH *, false AS repOf // Evaluated only for non-members; members are decided by orgActor alone. WITH *, CASE WHEN orgActor IS NULL THEN EXISTS { MATCH (currentUser)<-[:FOR_USER]-(da:Actor{delpending:false})<-[:STUDY_TO_DELEGATED_ACTOR]-(st:Study{delpending:false})-[:STUDY_TO_ORG]->(targetOrg), (da)-[:APPOINTED_AS]->(dr:Role)<-[:APPOINTED_AS]-(sa:Actor{delpending:false}), (da)-[:DELEGATED_FROM]->(sa)<-[:ORGANIZATION_TO_ACTOR]-(:Organization{alias:$tildaScaleAlias}) WHERE st.srcorgid = targetOrg.tildaid AND da.state <> ? AND sa.state <> ? AND $orgDelegatedTag IN apoc.text.split(coalesce(dr.tags, ?), ?) } ELSE false END as delegated RETURN CASE WHEN orgActor is not null THEN currentUser WHEN delegated THEN currentUser WHEN repOf THEN currentUser WHEN supports is not null THEN coalesce(supportUser, currentUser) ELSE currentUser END as user, CASE WHEN orgActor is not null OR delegated OR repOf OR supports is not null THEN targetOrg ELSE null END as org, currentUser as tokenUser
12 dashql, docsvc, enrollsvc, execsvc, finsvc, onboardingsvc, patientsvc, regsvc, schedsvc, studiosvc, tusker, workplansvc
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpe…
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) OPTIONAL MATCH (supportUser:User{email:$supportUserEmail}) OPTIONAL MATCH (targetOrg:Organization{delpending:false, alias:$orgAlias}) // A deactivated (Inactive) org actor is not a membership (ENG-?). OPTIONAL MATCH (currentUser)-[:FOR_USER]-(orgActor:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(targetOrg) WHERE coalesce(orgActor.state, ?) <> ? OPTIONAL MATCH (currentUser)-[supports:SUPPORTS_ORG]-(targetOrg) WITH *, false AS repOf // Evaluated only for non-members; members are decided by orgActor alone. WITH *, CASE WHEN orgActor IS NULL THEN EXISTS { MATCH (currentUser)<-[:FOR_USER]-(da:Actor{delpending:false})<-[:STUDY_TO_DELEGATED_ACTOR]-(st:Study{delpending:false})-[:STUDY_TO_ORG]->(targetOrg), (da)-[:APPOINTED_AS]->(dr:Role)<-[:APPOINTED_AS]-(sa:Actor{delpending:false}), (da)-[:DELEGATED_FROM]->(sa)<-[:ORGANIZATION_TO_ACTOR]-(:Organization{alias:$tildaScaleAlias}) WHERE st.srcorgid = targetOrg.tildaid AND da.state <> ? AND sa.state <> ? AND $orgDelegatedTag IN apoc.text.split(coalesce(dr.tags, ?), ?) } ELSE false END as delegated RETURN CASE WHEN orgActor is not null THEN currentUser WHEN delegated THEN currentUser WHEN repOf THEN currentUser WHEN supports is not null THEN coalesce(supportUser, currentUser) ELSE currentUser END as user, CASE WHEN orgActor is not null OR delegated OR repOf OR supports is not null THEN targetOrg ELSE null END as org, currentUser as tokenUser