Create a gist now

Instantly share code, notes, and snippets.

start c=node:companies(id={id})
match
c<-[:parent_company*0..]-n
with n
match
n-[:defines_business_process]->bp-[:has_cycle]->cm
where
cm.measureDate>={measureStartDate} and cm.measureDate<={measureEndDate}
with cm
match
(cm)-[:cycle_metric]->m-[:metric_activity]->ma-[:metric_unit]->u<-[:alert_for_unit]-(a)
where
a.alertDate=cm.measureDate and a.fromEntityType={type}
with a,ma
match
(r)<-[:for_inspection_result]-a-[:alert_for_inspection]->i
where
(i)<-[:metric_inspection]-(ma)
return a.id as alertId, r.value as resultValue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment