Query2_original.sql

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