public
Last active

  • Download Gist
Query2_original.sql
SQL
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
start c=node:companies(id={companyId})
match
c<-[:parent_company*0..]-n
with n
match
n-[:defines_process"]->bp-[:has_cycle]->cm-[:cycle_metric]->m-[:metric_activity]->ma-[:metric_unit]->u
where
cm.measureDate>={measureStartDate} and cm.measureDate<={measureEndDate}
with ma,u,cm
match
ma-[:metric_unit]->(u)<-[:alert_for_unit]-(a)-[:alert_for_inspection]->i-[:has_result]->r<-[:for_inspection_result]-a
where
a.alertDate=cm.measureDate
and a.fromEntityType={type}
return distinct a.id as alertId, r.value as resultValue

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.