Xray
daily rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 3 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 07:46:24.
› →|
updated 21h 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 24

stored 21h ago all 24coupling through shared query shapes

Which services on test27 read the same graph over the last 3d — 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

studiosvcstudiosvcworkplansvcworkplansvcdocsvcdocsvctuskertuskeronboardingsvconboardingsvcdocprocdocprocexecsvcexecsvcbudgetsvcbudgetsvctmfsynctmfsyncregsvcregsvcvirtual-assistantvirtual-assistantdata_monitordata_monitorenrollsvcenrollsvcadvpsvcadvpsvcfinsvcfinsvcdashrsvcdashrsvcauthzdauthzdfeedsvcfeedsvcpatientsvcpatientsvcschedsvcschedsvcnotifsvcnotifsvcchat-agentchat-agentontologysvcontologysvcdashqldashqlstudiosvc ↔ workplansvc: 3 shared shapesstudiosvc ↔ docsvc: 43 shared shapesstudiosvc ↔ tusker: 7 shared shapesstudiosvc ↔ onboardingsvc: 42 shared shapesstudiosvc ↔ docproc: 1 shared shapesstudiosvc ↔ execsvc: 43 shared shapesstudiosvc ↔ budgetsvc: 1 shared shapesstudiosvc ↔ tmfsync: 1 shared shapesstudiosvc ↔ regsvc: 7 shared shapesstudiosvc ↔ virtual-assistant: 1 shared shapesstudiosvc ↔ data_monitor: 1 shared shapesstudiosvc ↔ enrollsvc: 30 shared shapesstudiosvc ↔ advpsvc: 1 shared shapesstudiosvc ↔ finsvc: 1 shared shapesstudiosvc ↔ dashrsvc: 1 shared shapesstudiosvc ↔ authzd: 2 shared shapesstudiosvc ↔ feedsvc: 1 shared shapesstudiosvc ↔ patientsvc: 3 shared shapesstudiosvc ↔ schedsvc: 8 shared shapesstudiosvc ↔ notifsvc: 1 shared shapesstudiosvc ↔ chat-agent: 1 shared shapesstudiosvc ↔ ontologysvc: 1 shared shapesstudiosvc ↔ dashql: 16 shared shapesworkplansvc ↔ studiosvc: 3 shared shapesworkplansvc ↔ docsvc: 3 shared shapesworkplansvc ↔ tusker: 2 shared shapesworkplansvc ↔ onboardingsvc: 3 shared shapesworkplansvc ↔ docproc: 1 shared shapesworkplansvc ↔ execsvc: 2 shared shapesworkplansvc ↔ budgetsvc: 1 shared shapesworkplansvc ↔ tmfsync: 1 shared shapesworkplansvc ↔ regsvc: 2 shared shapesworkplansvc ↔ virtual-assistant: 1 shared shapesworkplansvc ↔ data_monitor: 1 shared shapesworkplansvc ↔ enrollsvc: 2 shared shapesworkplansvc ↔ advpsvc: 1 shared shapesworkplansvc ↔ finsvc: 1 shared shapesworkplansvc ↔ dashrsvc: 1 shared shapesworkplansvc ↔ authzd: 1 shared shapesworkplansvc ↔ feedsvc: 1 shared shapesworkplansvc ↔ patientsvc: 2 shared shapesworkplansvc ↔ schedsvc: 2 shared shapesworkplansvc ↔ notifsvc: 1 shared shapesworkplansvc ↔ chat-agent: 1 shared shapesworkplansvc ↔ ontologysvc: 1 shared shapesworkplansvc ↔ dashql: 2 shared shapesdocsvc ↔ studiosvc: 43 shared shapesdocsvc ↔ workplansvc: 3 shared shapesdocsvc ↔ tusker: 12 shared shapesdocsvc ↔ onboardingsvc: 84 shared shapesdocsvc ↔ docproc: 1 shared shapesdocsvc ↔ execsvc: 69 shared shapesdocsvc ↔ budgetsvc: 1 shared shapesdocsvc ↔ tmfsync: 1 shared shapesdocsvc ↔ regsvc: 11 shared shapesdocsvc ↔ virtual-assistant: 1 shared shapesdocsvc ↔ data_monitor: 1 shared shapesdocsvc ↔ enrollsvc: 42 shared shapesdocsvc ↔ advpsvc: 1 shared shapesdocsvc ↔ finsvc: 1 shared shapesdocsvc ↔ dashrsvc: 3 shared shapesdocsvc ↔ authzd: 11 shared shapesdocsvc ↔ feedsvc: 1 shared shapesdocsvc ↔ patientsvc: 3 shared shapesdocsvc ↔ schedsvc: 8 shared shapesdocsvc ↔ notifsvc: 1 shared shapesdocsvc ↔ chat-agent: 1 shared shapesdocsvc ↔ ontologysvc: 1 shared shapesdocsvc ↔ dashql: 20 shared shapestusker ↔ studiosvc: 7 shared shapestusker ↔ workplansvc: 2 shared shapestusker ↔ docsvc: 12 shared shapestusker ↔ onboardingsvc: 10 shared shapestusker ↔ docproc: 1 shared shapestusker ↔ execsvc: 20 shared shapestusker ↔ budgetsvc: 1 shared shapestusker ↔ tmfsync: 1 shared shapestusker ↔ regsvc: 7 shared shapestusker ↔ virtual-assistant: 1 shared shapestusker ↔ data_monitor: 1 shared shapestusker ↔ enrollsvc: 8 shared shapestusker ↔ advpsvc: 1 shared shapestusker ↔ finsvc: 1 shared shapestusker ↔ dashrsvc: 1 shared shapestusker ↔ authzd: 4 shared shapestusker ↔ feedsvc: 1 shared shapestusker ↔ patientsvc: 3 shared shapestusker ↔ schedsvc: 13 shared shapestusker ↔ notifsvc: 1 shared shapestusker ↔ chat-agent: 1 shared shapestusker ↔ ontologysvc: 1 shared shapestusker ↔ dashql: 8 shared shapesonboardingsvc ↔ studiosvc: 42 shared shapesonboardingsvc ↔ workplansvc: 3 shared shapesonboardingsvc ↔ docsvc: 84 shared shapesonboardingsvc ↔ tusker: 10 shared shapesonboardingsvc ↔ docproc: 1 shared shapesonboardingsvc ↔ execsvc: 85 shared shapesonboardingsvc ↔ budgetsvc: 1 shared shapesonboardingsvc ↔ tmfsync: 1 shared shapesonboardingsvc ↔ regsvc: 11 shared shapesonboardingsvc ↔ virtual-assistant: 1 shared shapesonboardingsvc ↔ data_monitor: 1 shared shapesonboardingsvc ↔ enrollsvc: 59 shared shapesonboardingsvc ↔ advpsvc: 1 shared shapesonboardingsvc ↔ finsvc: 1 shared shapesonboardingsvc ↔ dashrsvc: 1 shared shapesonboardingsvc ↔ authzd: 15 shared shapesonboardingsvc ↔ feedsvc: 1 shared shapesonboardingsvc ↔ patientsvc: 3 shared shapesonboardingsvc ↔ schedsvc: 10 shared shapesonboardingsvc ↔ notifsvc: 9 shared shapesonboardingsvc ↔ chat-agent: 1 shared shapesonboardingsvc ↔ ontologysvc: 1 shared shapesonboardingsvc ↔ dashql: 19 shared shapesdocproc ↔ studiosvc: 1 shared shapesdocproc ↔ workplansvc: 1 shared shapesdocproc ↔ docsvc: 1 shared shapesdocproc ↔ tusker: 1 shared shapesdocproc ↔ onboardingsvc: 1 shared shapesdocproc ↔ execsvc: 1 shared shapesdocproc ↔ budgetsvc: 1 shared shapesdocproc ↔ tmfsync: 23 shared shapesdocproc ↔ regsvc: 1 shared shapesdocproc ↔ virtual-assistant: 33 shared shapesdocproc ↔ data_monitor: 7 shared shapesdocproc ↔ enrollsvc: 1 shared shapesdocproc ↔ advpsvc: 1 shared shapesdocproc ↔ finsvc: 1 shared shapesdocproc ↔ dashrsvc: 1 shared shapesdocproc ↔ authzd: 1 shared shapesdocproc ↔ feedsvc: 28 shared shapesdocproc ↔ patientsvc: 1 shared shapesdocproc ↔ schedsvc: 1 shared shapesdocproc ↔ notifsvc: 1 shared shapesdocproc ↔ chat-agent: 14 shared shapesdocproc ↔ ontologysvc: 2 shared shapesdocproc ↔ dashql: 1 shared shapesexecsvc ↔ studiosvc: 43 shared shapesexecsvc ↔ workplansvc: 2 shared shapesexecsvc ↔ docsvc: 69 shared shapesexecsvc ↔ tusker: 20 shared shapesexecsvc ↔ onboardingsvc: 85 shared shapesexecsvc ↔ docproc: 1 shared shapesexecsvc ↔ budgetsvc: 1 shared shapesexecsvc ↔ tmfsync: 1 shared shapesexecsvc ↔ regsvc: 13 shared shapesexecsvc ↔ virtual-assistant: 1 shared shapesexecsvc ↔ data_monitor: 1 shared shapesexecsvc ↔ enrollsvc: 53 shared shapesexecsvc ↔ advpsvc: 1 shared shapesexecsvc ↔ finsvc: 1 shared shapesexecsvc ↔ dashrsvc: 1 shared shapesexecsvc ↔ authzd: 7 shared shapesexecsvc ↔ feedsvc: 1 shared shapesexecsvc ↔ patientsvc: 3 shared shapesexecsvc ↔ schedsvc: 10 shared shapesexecsvc ↔ notifsvc: 2 shared shapesexecsvc ↔ chat-agent: 1 shared shapesexecsvc ↔ ontologysvc: 1 shared shapesexecsvc ↔ dashql: 20 shared shapesbudgetsvc ↔ studiosvc: 1 shared shapesbudgetsvc ↔ workplansvc: 1 shared shapesbudgetsvc ↔ docsvc: 1 shared shapesbudgetsvc ↔ tusker: 1 shared shapesbudgetsvc ↔ onboardingsvc: 1 shared shapesbudgetsvc ↔ docproc: 1 shared shapesbudgetsvc ↔ execsvc: 1 shared shapesbudgetsvc ↔ tmfsync: 1 shared shapesbudgetsvc ↔ regsvc: 1 shared shapesbudgetsvc ↔ virtual-assistant: 1 shared shapesbudgetsvc ↔ data_monitor: 1 shared shapesbudgetsvc ↔ enrollsvc: 1 shared shapesbudgetsvc ↔ advpsvc: 1 shared shapesbudgetsvc ↔ finsvc: 1 shared shapesbudgetsvc ↔ dashrsvc: 1 shared shapesbudgetsvc ↔ authzd: 1 shared shapesbudgetsvc ↔ feedsvc: 1 shared shapesbudgetsvc ↔ patientsvc: 1 shared shapesbudgetsvc ↔ schedsvc: 1 shared shapesbudgetsvc ↔ notifsvc: 1 shared shapesbudgetsvc ↔ chat-agent: 1 shared shapesbudgetsvc ↔ ontologysvc: 1 shared shapesbudgetsvc ↔ dashql: 1 shared shapestmfsync ↔ studiosvc: 1 shared shapestmfsync ↔ workplansvc: 1 shared shapestmfsync ↔ docsvc: 1 shared shapestmfsync ↔ tusker: 1 shared shapestmfsync ↔ onboardingsvc: 1 shared shapestmfsync ↔ docproc: 23 shared shapestmfsync ↔ execsvc: 1 shared shapestmfsync ↔ budgetsvc: 1 shared shapestmfsync ↔ regsvc: 1 shared shapestmfsync ↔ virtual-assistant: 18 shared shapestmfsync ↔ data_monitor: 3 shared shapestmfsync ↔ enrollsvc: 1 shared shapestmfsync ↔ advpsvc: 1 shared shapestmfsync ↔ finsvc: 1 shared shapestmfsync ↔ dashrsvc: 1 shared shapestmfsync ↔ authzd: 1 shared shapestmfsync ↔ feedsvc: 28 shared shapestmfsync ↔ patientsvc: 1 shared shapestmfsync ↔ schedsvc: 1 shared shapestmfsync ↔ notifsvc: 1 shared shapestmfsync ↔ chat-agent: 15 shared shapestmfsync ↔ ontologysvc: 3 shared shapestmfsync ↔ dashql: 1 shared shapesregsvc ↔ studiosvc: 7 shared shapesregsvc ↔ workplansvc: 2 shared shapesregsvc ↔ docsvc: 11 shared shapesregsvc ↔ tusker: 7 shared shapesregsvc ↔ onboardingsvc: 11 shared shapesregsvc ↔ docproc: 1 shared shapesregsvc ↔ execsvc: 13 shared shapesregsvc ↔ budgetsvc: 1 shared shapesregsvc ↔ tmfsync: 1 shared shapesregsvc ↔ virtual-assistant: 1 shared shapesregsvc ↔ data_monitor: 1 shared shapesregsvc ↔ enrollsvc: 8 shared shapesregsvc ↔ advpsvc: 1 shared shapesregsvc ↔ finsvc: 1 shared shapesregsvc ↔ dashrsvc: 1 shared shapesregsvc ↔ authzd: 3 shared shapesregsvc ↔ feedsvc: 1 shared shapesregsvc ↔ patientsvc: 2 shared shapesregsvc ↔ schedsvc: 8 shared shapesregsvc ↔ notifsvc: 1 shared shapesregsvc ↔ chat-agent: 1 shared shapesregsvc ↔ ontologysvc: 1 shared shapesregsvc ↔ dashql: 8 shared shapesvirtual-assistant ↔ studiosvc: 1 shared shapesvirtual-assistant ↔ workplansvc: 1 shared shapesvirtual-assistant ↔ docsvc: 1 shared shapesvirtual-assistant ↔ tusker: 1 shared shapesvirtual-assistant ↔ onboardingsvc: 1 shared shapesvirtual-assistant ↔ docproc: 33 shared shapesvirtual-assistant ↔ execsvc: 1 shared shapesvirtual-assistant ↔ budgetsvc: 1 shared shapesvirtual-assistant ↔ tmfsync: 18 shared shapesvirtual-assistant ↔ regsvc: 1 shared shapesvirtual-assistant ↔ data_monitor: 7 shared shapesvirtual-assistant ↔ enrollsvc: 1 shared shapesvirtual-assistant ↔ advpsvc: 1 shared shapesvirtual-assistant ↔ finsvc: 1 shared shapesvirtual-assistant ↔ dashrsvc: 1 shared shapesvirtual-assistant ↔ authzd: 1 shared shapesvirtual-assistant ↔ feedsvc: 25 shared shapesvirtual-assistant ↔ patientsvc: 1 shared shapesvirtual-assistant ↔ schedsvc: 1 shared shapesvirtual-assistant ↔ notifsvc: 1 shared shapesvirtual-assistant ↔ chat-agent: 17 shared shapesvirtual-assistant ↔ ontologysvc: 2 shared shapesvirtual-assistant ↔ dashql: 1 shared shapesdata_monitor ↔ studiosvc: 1 shared shapesdata_monitor ↔ workplansvc: 1 shared shapesdata_monitor ↔ docsvc: 1 shared shapesdata_monitor ↔ tusker: 1 shared shapesdata_monitor ↔ onboardingsvc: 1 shared shapesdata_monitor ↔ docproc: 7 shared shapesdata_monitor ↔ execsvc: 1 shared shapesdata_monitor ↔ budgetsvc: 1 shared shapesdata_monitor ↔ tmfsync: 3 shared shapesdata_monitor ↔ regsvc: 1 shared shapesdata_monitor ↔ virtual-assistant: 7 shared shapesdata_monitor ↔ enrollsvc: 1 shared shapesdata_monitor ↔ advpsvc: 1 shared shapesdata_monitor ↔ finsvc: 1 shared shapesdata_monitor ↔ dashrsvc: 1 shared shapesdata_monitor ↔ authzd: 1 shared shapesdata_monitor ↔ feedsvc: 4 shared shapesdata_monitor ↔ patientsvc: 1 shared shapesdata_monitor ↔ schedsvc: 1 shared shapesdata_monitor ↔ notifsvc: 1 shared shapesdata_monitor ↔ chat-agent: 9 shared shapesdata_monitor ↔ ontologysvc: 1 shared shapesdata_monitor ↔ dashql: 1 shared shapesenrollsvc ↔ studiosvc: 30 shared shapesenrollsvc ↔ workplansvc: 2 shared shapesenrollsvc ↔ docsvc: 42 shared shapesenrollsvc ↔ tusker: 8 shared shapesenrollsvc ↔ onboardingsvc: 59 shared shapesenrollsvc ↔ docproc: 1 shared shapesenrollsvc ↔ execsvc: 53 shared shapesenrollsvc ↔ budgetsvc: 1 shared shapesenrollsvc ↔ tmfsync: 1 shared shapesenrollsvc ↔ regsvc: 8 shared shapesenrollsvc ↔ virtual-assistant: 1 shared shapesenrollsvc ↔ data_monitor: 1 shared shapesenrollsvc ↔ advpsvc: 6 shared shapesenrollsvc ↔ finsvc: 1 shared shapesenrollsvc ↔ dashrsvc: 1 shared shapesenrollsvc ↔ authzd: 5 shared shapesenrollsvc ↔ feedsvc: 1 shared shapesenrollsvc ↔ patientsvc: 3 shared shapesenrollsvc ↔ schedsvc: 9 shared shapesenrollsvc ↔ notifsvc: 2 shared shapesenrollsvc ↔ chat-agent: 1 shared shapesenrollsvc ↔ ontologysvc: 1 shared shapesenrollsvc ↔ dashql: 18 shared shapesadvpsvc ↔ studiosvc: 1 shared shapesadvpsvc ↔ workplansvc: 1 shared shapesadvpsvc ↔ docsvc: 1 shared shapesadvpsvc ↔ tusker: 1 shared shapesadvpsvc ↔ onboardingsvc: 1 shared shapesadvpsvc ↔ docproc: 1 shared shapesadvpsvc ↔ execsvc: 1 shared shapesadvpsvc ↔ budgetsvc: 1 shared shapesadvpsvc ↔ tmfsync: 1 shared shapesadvpsvc ↔ regsvc: 1 shared shapesadvpsvc ↔ virtual-assistant: 1 shared shapesadvpsvc ↔ data_monitor: 1 shared shapesadvpsvc ↔ enrollsvc: 6 shared shapesadvpsvc ↔ finsvc: 1 shared shapesadvpsvc ↔ dashrsvc: 1 shared shapesadvpsvc ↔ authzd: 1 shared shapesadvpsvc ↔ feedsvc: 1 shared shapesadvpsvc ↔ patientsvc: 1 shared shapesadvpsvc ↔ schedsvc: 1 shared shapesadvpsvc ↔ notifsvc: 1 shared shapesadvpsvc ↔ chat-agent: 1 shared shapesadvpsvc ↔ ontologysvc: 1 shared shapesadvpsvc ↔ dashql: 1 shared shapesfinsvc ↔ studiosvc: 1 shared shapesfinsvc ↔ workplansvc: 1 shared shapesfinsvc ↔ docsvc: 1 shared shapesfinsvc ↔ tusker: 1 shared shapesfinsvc ↔ onboardingsvc: 1 shared shapesfinsvc ↔ docproc: 1 shared shapesfinsvc ↔ execsvc: 1 shared shapesfinsvc ↔ budgetsvc: 1 shared shapesfinsvc ↔ tmfsync: 1 shared shapesfinsvc ↔ regsvc: 1 shared shapesfinsvc ↔ virtual-assistant: 1 shared shapesfinsvc ↔ data_monitor: 1 shared shapesfinsvc ↔ enrollsvc: 1 shared shapesfinsvc ↔ advpsvc: 1 shared shapesfinsvc ↔ dashrsvc: 1 shared shapesfinsvc ↔ authzd: 1 shared shapesfinsvc ↔ feedsvc: 1 shared shapesfinsvc ↔ patientsvc: 1 shared shapesfinsvc ↔ schedsvc: 1 shared shapesfinsvc ↔ notifsvc: 1 shared shapesfinsvc ↔ chat-agent: 1 shared shapesfinsvc ↔ ontologysvc: 1 shared shapesfinsvc ↔ dashql: 1 shared shapesdashrsvc ↔ studiosvc: 1 shared shapesdashrsvc ↔ workplansvc: 1 shared shapesdashrsvc ↔ docsvc: 3 shared shapesdashrsvc ↔ tusker: 1 shared shapesdashrsvc ↔ onboardingsvc: 1 shared shapesdashrsvc ↔ docproc: 1 shared shapesdashrsvc ↔ execsvc: 1 shared shapesdashrsvc ↔ budgetsvc: 1 shared shapesdashrsvc ↔ tmfsync: 1 shared shapesdashrsvc ↔ regsvc: 1 shared shapesdashrsvc ↔ virtual-assistant: 1 shared shapesdashrsvc ↔ data_monitor: 1 shared shapesdashrsvc ↔ enrollsvc: 1 shared shapesdashrsvc ↔ advpsvc: 1 shared shapesdashrsvc ↔ finsvc: 1 shared shapesdashrsvc ↔ authzd: 1 shared shapesdashrsvc ↔ feedsvc: 1 shared shapesdashrsvc ↔ patientsvc: 1 shared shapesdashrsvc ↔ schedsvc: 1 shared shapesdashrsvc ↔ notifsvc: 1 shared shapesdashrsvc ↔ chat-agent: 1 shared shapesdashrsvc ↔ ontologysvc: 1 shared shapesdashrsvc ↔ dashql: 1 shared shapesauthzd ↔ studiosvc: 2 shared shapesauthzd ↔ workplansvc: 1 shared shapesauthzd ↔ docsvc: 11 shared shapesauthzd ↔ tusker: 4 shared shapesauthzd ↔ onboardingsvc: 15 shared shapesauthzd ↔ docproc: 1 shared shapesauthzd ↔ execsvc: 7 shared shapesauthzd ↔ budgetsvc: 1 shared shapesauthzd ↔ tmfsync: 1 shared shapesauthzd ↔ regsvc: 3 shared shapesauthzd ↔ virtual-assistant: 1 shared shapesauthzd ↔ data_monitor: 1 shared shapesauthzd ↔ enrollsvc: 5 shared shapesauthzd ↔ advpsvc: 1 shared shapesauthzd ↔ finsvc: 1 shared shapesauthzd ↔ dashrsvc: 1 shared shapesauthzd ↔ feedsvc: 1 shared shapesauthzd ↔ patientsvc: 1 shared shapesauthzd ↔ schedsvc: 1 shared shapesauthzd ↔ notifsvc: 1 shared shapesauthzd ↔ chat-agent: 1 shared shapesauthzd ↔ ontologysvc: 1 shared shapesauthzd ↔ dashql: 2 shared shapesfeedsvc ↔ studiosvc: 1 shared shapesfeedsvc ↔ workplansvc: 1 shared shapesfeedsvc ↔ docsvc: 1 shared shapesfeedsvc ↔ tusker: 1 shared shapesfeedsvc ↔ onboardingsvc: 1 shared shapesfeedsvc ↔ docproc: 28 shared shapesfeedsvc ↔ execsvc: 1 shared shapesfeedsvc ↔ budgetsvc: 1 shared shapesfeedsvc ↔ tmfsync: 28 shared shapesfeedsvc ↔ regsvc: 1 shared shapesfeedsvc ↔ virtual-assistant: 25 shared shapesfeedsvc ↔ data_monitor: 4 shared shapesfeedsvc ↔ enrollsvc: 1 shared shapesfeedsvc ↔ advpsvc: 1 shared shapesfeedsvc ↔ finsvc: 1 shared shapesfeedsvc ↔ dashrsvc: 1 shared shapesfeedsvc ↔ authzd: 1 shared shapesfeedsvc ↔ patientsvc: 1 shared shapesfeedsvc ↔ schedsvc: 1 shared shapesfeedsvc ↔ notifsvc: 1 shared shapesfeedsvc ↔ chat-agent: 10 shared shapesfeedsvc ↔ ontologysvc: 3 shared shapesfeedsvc ↔ dashql: 1 shared shapespatientsvc ↔ studiosvc: 3 shared shapespatientsvc ↔ workplansvc: 2 shared shapespatientsvc ↔ docsvc: 3 shared shapespatientsvc ↔ tusker: 3 shared shapespatientsvc ↔ onboardingsvc: 3 shared shapespatientsvc ↔ docproc: 1 shared shapespatientsvc ↔ execsvc: 3 shared shapespatientsvc ↔ budgetsvc: 1 shared shapespatientsvc ↔ tmfsync: 1 shared shapespatientsvc ↔ regsvc: 2 shared shapespatientsvc ↔ virtual-assistant: 1 shared shapespatientsvc ↔ data_monitor: 1 shared shapespatientsvc ↔ enrollsvc: 3 shared shapespatientsvc ↔ advpsvc: 1 shared shapespatientsvc ↔ finsvc: 1 shared shapespatientsvc ↔ dashrsvc: 1 shared shapespatientsvc ↔ authzd: 1 shared shapespatientsvc ↔ feedsvc: 1 shared shapespatientsvc ↔ schedsvc: 3 shared shapespatientsvc ↔ notifsvc: 1 shared shapespatientsvc ↔ chat-agent: 1 shared shapespatientsvc ↔ ontologysvc: 1 shared shapespatientsvc ↔ dashql: 3 shared shapesschedsvc ↔ studiosvc: 8 shared shapesschedsvc ↔ workplansvc: 2 shared shapesschedsvc ↔ docsvc: 8 shared shapesschedsvc ↔ tusker: 13 shared shapesschedsvc ↔ onboardingsvc: 10 shared shapesschedsvc ↔ docproc: 1 shared shapesschedsvc ↔ execsvc: 10 shared shapesschedsvc ↔ budgetsvc: 1 shared shapesschedsvc ↔ tmfsync: 1 shared shapesschedsvc ↔ regsvc: 8 shared shapesschedsvc ↔ virtual-assistant: 1 shared shapesschedsvc ↔ data_monitor: 1 shared shapesschedsvc ↔ enrollsvc: 9 shared shapesschedsvc ↔ advpsvc: 1 shared shapesschedsvc ↔ finsvc: 1 shared shapesschedsvc ↔ dashrsvc: 1 shared shapesschedsvc ↔ authzd: 1 shared shapesschedsvc ↔ feedsvc: 1 shared shapesschedsvc ↔ patientsvc: 3 shared shapesschedsvc ↔ notifsvc: 9 shared shapesschedsvc ↔ chat-agent: 1 shared shapesschedsvc ↔ ontologysvc: 1 shared shapesschedsvc ↔ dashql: 10 shared shapesnotifsvc ↔ studiosvc: 1 shared shapesnotifsvc ↔ workplansvc: 1 shared shapesnotifsvc ↔ docsvc: 1 shared shapesnotifsvc ↔ tusker: 1 shared shapesnotifsvc ↔ onboardingsvc: 9 shared shapesnotifsvc ↔ docproc: 1 shared shapesnotifsvc ↔ execsvc: 2 shared shapesnotifsvc ↔ budgetsvc: 1 shared shapesnotifsvc ↔ tmfsync: 1 shared shapesnotifsvc ↔ regsvc: 1 shared shapesnotifsvc ↔ virtual-assistant: 1 shared shapesnotifsvc ↔ data_monitor: 1 shared shapesnotifsvc ↔ enrollsvc: 2 shared shapesnotifsvc ↔ advpsvc: 1 shared shapesnotifsvc ↔ finsvc: 1 shared shapesnotifsvc ↔ dashrsvc: 1 shared shapesnotifsvc ↔ authzd: 1 shared shapesnotifsvc ↔ feedsvc: 1 shared shapesnotifsvc ↔ patientsvc: 1 shared shapesnotifsvc ↔ schedsvc: 9 shared shapesnotifsvc ↔ chat-agent: 1 shared shapesnotifsvc ↔ ontologysvc: 1 shared shapesnotifsvc ↔ dashql: 1 shared shapeschat-agent ↔ studiosvc: 1 shared shapeschat-agent ↔ workplansvc: 1 shared shapeschat-agent ↔ docsvc: 1 shared shapeschat-agent ↔ tusker: 1 shared shapeschat-agent ↔ onboardingsvc: 1 shared shapeschat-agent ↔ docproc: 14 shared shapeschat-agent ↔ execsvc: 1 shared shapeschat-agent ↔ budgetsvc: 1 shared shapeschat-agent ↔ tmfsync: 15 shared shapeschat-agent ↔ regsvc: 1 shared shapeschat-agent ↔ virtual-assistant: 17 shared shapeschat-agent ↔ data_monitor: 9 shared shapeschat-agent ↔ enrollsvc: 1 shared shapeschat-agent ↔ advpsvc: 1 shared shapeschat-agent ↔ finsvc: 1 shared shapeschat-agent ↔ dashrsvc: 1 shared shapeschat-agent ↔ authzd: 1 shared shapeschat-agent ↔ feedsvc: 10 shared shapeschat-agent ↔ patientsvc: 1 shared shapeschat-agent ↔ schedsvc: 1 shared shapeschat-agent ↔ notifsvc: 1 shared shapeschat-agent ↔ ontologysvc: 2 shared shapeschat-agent ↔ dashql: 1 shared shapesontologysvc ↔ studiosvc: 1 shared shapesontologysvc ↔ workplansvc: 1 shared shapesontologysvc ↔ docsvc: 1 shared shapesontologysvc ↔ tusker: 1 shared shapesontologysvc ↔ onboardingsvc: 1 shared shapesontologysvc ↔ docproc: 2 shared shapesontologysvc ↔ execsvc: 1 shared shapesontologysvc ↔ budgetsvc: 1 shared shapesontologysvc ↔ tmfsync: 3 shared shapesontologysvc ↔ regsvc: 1 shared shapesontologysvc ↔ virtual-assistant: 2 shared shapesontologysvc ↔ data_monitor: 1 shared shapesontologysvc ↔ enrollsvc: 1 shared shapesontologysvc ↔ advpsvc: 1 shared shapesontologysvc ↔ finsvc: 1 shared shapesontologysvc ↔ dashrsvc: 1 shared shapesontologysvc ↔ authzd: 1 shared shapesontologysvc ↔ feedsvc: 3 shared shapesontologysvc ↔ patientsvc: 1 shared shapesontologysvc ↔ schedsvc: 1 shared shapesontologysvc ↔ notifsvc: 1 shared shapesontologysvc ↔ chat-agent: 2 shared shapesontologysvc ↔ dashql: 1 shared shapesdashql ↔ studiosvc: 16 shared shapesdashql ↔ workplansvc: 2 shared shapesdashql ↔ docsvc: 20 shared shapesdashql ↔ tusker: 8 shared shapesdashql ↔ onboardingsvc: 19 shared shapesdashql ↔ docproc: 1 shared shapesdashql ↔ execsvc: 20 shared shapesdashql ↔ budgetsvc: 1 shared shapesdashql ↔ tmfsync: 1 shared shapesdashql ↔ regsvc: 8 shared shapesdashql ↔ virtual-assistant: 1 shared shapesdashql ↔ data_monitor: 1 shared shapesdashql ↔ enrollsvc: 18 shared shapesdashql ↔ advpsvc: 1 shared shapesdashql ↔ finsvc: 1 shared shapesdashql ↔ dashrsvc: 1 shared shapesdashql ↔ authzd: 2 shared shapesdashql ↔ feedsvc: 1 shared shapesdashql ↔ patientsvc: 3 shared shapesdashql ↔ schedsvc: 10 shared shapesdashql ↔ notifsvc: 1 shared shapesdashql ↔ chat-agent: 1 shared shapesdashql ↔ ontologysvc: 1 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
24 advpsvc, authzd, budgetsvc, chat-agent, dashql, dashrsvc, data_monitor, docproc, docsvc, enrollsvc, execsvc, feedsvc, finsvc, notifsvc, onboardingsvc, ontologysvc, patientsvc, regsvc, schedsvc, studiosvc, tmfsync, tusker, virtual-assistant, workplansvc
MATCH(a:GraphV2{tildaid:$a_tildaid}) RETURN a
MATCH(a:GraphV2{tildaid:$a_tildaid}) RETURN a
11 dashql, docsvc, enrollsvc, execsvc, 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
9 dashql, docsvc, enrollsvc, execsvc, onboardingsvc, regsvc, schedsvc, studiosvc, tusker
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
9 dashql, docsvc, enrollsvc, execsvc, onboardingsvc, patientsvc, schedsvc, studiosvc, tusker
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
9 dashql, docsvc, enrollsvc, execsvc, onboardingsvc, regsvc, schedsvc, studiosvc, tusker
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
8 dashql, docsvc, enrollsvc, execsvc, onboardingsvc, schedsvc, studiosvc, tusker
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
8 dashql, docsvc, enrollsvc, execsvc, onboardingsvc, schedsvc, studiosvc, tusker
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
7 dashql, docsvc, enrollsvc, execsvc, onboardingsvc, regsvc, studiosvc
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
7 dashql, docsvc, enrollsvc, execsvc, onboardingsvc, regsvc, studiosvc
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
7 dashql, docsvc, enrollsvc, execsvc, onboardingsvc, schedsvc, studiosvc
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
7 dashql, docsvc, enrollsvc, execsvc, onboardingsvc, regsvc, tusker
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
7 dashql, docsvc, enrollsvc, execsvc, onboardingsvc, regsvc, studiosvc
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