803.temp支持时序月.mql 478 B

123456789
  1. MATCH (staff:/mingdao1/staff)-[:is_member_of_project*1..1]->(project:/mingdao1/project WHERE attr1 = 'CN002859P') 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('2023-06-01 00:00:00','2023-06-10 23:59:59').find(name = 'CN002859P').unit('sum', '1M') AS "2024年1月工时" FROM /t0 t0 LIMIT 0, 20000
  3. /**output()**/;