| 12345678910 |
- SELECT temp01.person_account AS "工号", temp01.person_name AS "姓名", temp01.person_sz_g AS "师资归属单位", temp01.person_sort AS "编制类别", temp01.person_status AS "人员状态", temp01.person_staff_type AS "人员分类", temp01.org_name AS "人事所在单位", temp01.tech_duty_duty AS "专业技术职务", temp01.tech_duty_level AS "专业技术职务级别", temp01._univ_demo_tech_duty_name_0 AS "_univ_demo_tech_duty_name_0" FROM (MATCH (person:/univ_demo_local/person WHERE status = '在职' AND person_sort = '事业编' AND staff_type = '专任教师岗位')-[:person_to_org*1..1]->(org:/univ_demo_local/org WHERE dept_sort_name = '学术期刊'), (person)-[:person_to_tech_duty*1..1]->(tech_duty:/univ_demo_local/tech_duty WHERE duty = '教授' AND last_flag = '是') RETURN person.account AS "person_account", person.name AS "person_name", person.sz_g AS "person_sz_g", person.person_sort AS "person_sort", person.status AS "person_status", person.staff_type AS "person_staff_type", org.name AS "org_name", tech_duty.duty AS "tech_duty_duty", tech_duty.duty_level AS "tech_duty_level", tech_duty.name AS "_univ_demo_tech_duty_name_0") temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
- /**
- output()
- count(3)
- matchcount("姓名", "许嘉型", 1)
- matchcount("姓名", "苏越华", 1)
- matchcount("姓名", "汤章光", 1)
- **/
- ;
|
