315valido.mql 1.1 KB

123456789101112
  1. SELECT temp01.person_name AS "教职工姓名", temp01.person_account AS "教职工工号", temp01.society_name AS "学会名称", temp01.society_position AS "担任职务", temp01.appointment_start AS "聘期开始时间", temp01.appointment_end AS "聘期结束时间", temp01._univ_demo_szxxsb_xh_name_0 AS "_univ_demo_szxxsb_xh_name_0" FROM (MATCH (person:/univ_demo_local/person)-[:person_to_szxxsb_xh*1..1]->(society:/univ_demo_local/szxxsb_xh WHERE xm_name = '北京智能体研究学会' AND (pq_jssj is null OR pq_jssj > 1.777392e+12)) RETURN person.name AS "person_name", person.account AS "person_account", society.xm_name AS "society_name", society.wcrpm AS "society_position", society.pq_kssj AS "appointment_start", society.pq_jssj AS "appointment_end", society.name AS "_univ_demo_szxxsb_xh_name_0") temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
  2. /**
  3. output()
  4. count(5)
  5. matchcount("教职工姓名", "范俊统", 1)
  6. matchcount("教职工姓名", "苏宁祥", 1)
  7. matchcount("教职工姓名", "石构", 1)
  8. matchcount("教职工姓名", "许嘉型", 1)
  9. matchcount("教职工姓名", "吴辉忠", 1)
  10. **/
  11. ;