libf
/
odbtools


			
				
					
						
						
							1234567891011121314151617
							
MATCH (person:/univ_demo_local/person WHERE status = '在职' AND polity = '中共党员')-[:person_to_szxxsb_xh*1..1]->(society:/univ_demo_local/szxxsb_xh WHERE wcrpm = '会长' AND (pq_jssj is null OR pq_jssj > 1.777392e+12)) RETURN person.name AS "教职工姓名", person.account AS "工号", society.xm_name AS "学会名称", society.wcrpm AS "担任职务", society.name AS "_univ_demo_szxxsb_xh_name_0" WITH TIMEOUT = 6m
/**
output()
matchcount("教职工姓名", "罗勇", 1)
matchcount("教职工姓名", "苏宁祥", 1)
matchcount("教职工姓名", "卢竹焕", 1)
matchcount("教职工姓名", "许量", 1)
**/
;

SELECT temp01.society_name AS "学会名称", count(DISTINCT temp01.person_account) AS "中共党员人数" FROM (MATCH (person:/univ_demo_local/person WHERE status = '在职' AND polity = '中共党员')-[:person_to_szxxsb_xh*1..1]->(society:/univ_demo_local/szxxsb_xh WHERE wcrpm = '会长' AND (pq_jssj is null OR pq_jssj > 1.777392e+12)) RETURN person.account AS "person_account", society.xm_name AS "society_name") temp01 GROUP BY temp01."society_name" LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
count(4)
**/
;