802.temp支持时序.mql 459 B

123456789
  1. -- MATCH (staff:/mingdao1/staff)-[:is_member_of_project*1..1]->(project:/mingdao1/project WHERE attr1 = 'CN003570S') RETURN staff.attr0 AS "staff_no", staff.attr1 AS "staff_name", staff.staff_perf AS "staff_workload" INTO /t0;
  2. SELECT t0.staff_no AS "员工工号", t0.staff_name AS "员工姓名", t0.staff_workload.time('2025-01-01 00:00:00','2025-01-31 23:59:59').find(name = 'CN003570S').unit('sum', '1M') FROM /t0 t0 LIMIT 0, 20000
  3. /**
  4. output()
  5. **/
  6. ;