108.1.return.mql 489 B

1234567891011121314151617181920
  1. MATCH
  2. (contract:/mingdao1/contract WHERE attr15 > 34900 and attr15 < 35500)
  3. -[:is_contract_of_project*1..1]->
  4. (project:/mingdao1/project WHERE attr3 is not null),
  5. (sales:/mingdao1/staff)
  6. -[:is_duty_sales_of_contract*1..1]->
  7. (contract),
  8. (pm:/mingdao1/staff)
  9. -[:is_admin_of_project*1..1]->
  10. (project:/mingdao1/project WHERE attr3 is not null)
  11. return project.id, sales.id, pm.id, contract.id, _.path
  12. order by project.id, sales.id, pm.id, contract.id, _.path
  13. /**
  14. output()
  15. count(43)
  16. **/
  17. ;