odbtools/odbctest/mql/uino72/993.match.mql

MATCH 
(person:/univ_demo/person 
WHERE lx_date >= '2020-01-01 00:00:00' 
AND age <= 45 
AND status in ('在职', '报到中') 
AND person_sort = '事业编' 
AND staff_type = '专任教师岗位')
-[:person_to_org*1..1]->
(org:/univ_demo/org WHERE name = '计算机学院'), 
(person:/univ_demo/person 
WHERE lx_date >= '2020-01-01 00:00:00' 
AND age <= 45 
AND status in ('在职', '报到中') 
AND person_sort = '事业编' 
AND staff_type = '专任教师岗位')
-[:person_to_szxxsb*1..1]->
(honor:/univ_demo/szxxsb 
WHERE gccrc in ('国家级人才A类', '国家级人才B类', '国家级人才C类', '省部级人才') 
AND xm_name like '*青年人才计划*'), 
(person)
-[:person_to_master*1..1]->
(student:/univ_demo/student_master)
-[:own_paper*1..1]->
(paper:/univ_demo/paper 
WHERE level in ('A类', 'B类') 
AND type in ('期刊', '会议') 
AND keywords like '*人工智能*') 
RETURN person.id, org.id, honor.id, student.id, paper.id
/**
output()
count(8)
**/
;


MATCH 
(person:/univ_demo/person 
WHERE lx_date >= '2020-01-01 00:00:00' 
AND age <= 45 
AND status in ('在职', '报到中') 
AND person_sort = '事业编' 
AND staff_type = '专任教师岗位')
-[:person_to_org*1..1]->
(org:/univ_demo/org WHERE name = '计算机学院'), 
(person:/univ_demo/person 
WHERE lx_date >= '2020-01-01 00:00:00' 
AND age <= 45 
AND status in ('在职', '报到中') 
AND person_sort = '事业编' 
AND staff_type = '专任教师岗位')
-[:person_to_szxxsb*1..1]->
(honor:/univ_demo/szxxsb 
WHERE gccrc in ('国家级人才A类', '国家级人才B类', '国家级人才C类', '省部级人才') 
AND xm_name like '*青年人才计划*'), 
(person)
-[:person_to_master*1..1]->
(student:/univ_demo/student_master)
-[:own_paper*1..1]->
(paper:/univ_demo/paper 
WHERE level in ('A类', 'B类') 
AND type in ('期刊', '会议') 
AND keywords like '*人工智能*') 
RETURN person.name AS "teacher_name", person.account AS "teacher_account", org.name AS "org_name", org.up AS "org_up", honor.gccrc AS "honor_gccrc", student.name AS "student_name", student.account AS "student_account", paper.title AS "paper_title", paper.abstract AS "paper_abstract", paper.keywords AS "paper_keywords", paper.journals AS "paper_journals", paper.level AS "paper_level", paper.type AS "paper_type", paper.paper_file AS "paper_file", paper.name AS "_univ_demo_paper_name_0"
/**
output()
count(8)
**/
;




MATCH 
(person:/univ_demo/person 
WHERE lx_date >= '2020-01-01 00:00:00' 
AND age <= 45 
AND status in ('在职', '报到中') 
AND person_sort = '事业编' 
AND staff_type = '专任教师岗位')
-[:person_to_org*1..1]->
(org:/univ_demo/org WHERE name = '计算机学院'), 
(person:/univ_demo/person 
WHERE lx_date >= '2020-01-01 00:00:00' 
AND age <= 45 
AND status in ('在职', '报到中') 
AND person_sort = '事业编' 
AND staff_type = '专任教师岗位')
-[:person_to_szxxsb*1..1]->
(honor:/univ_demo/szxxsb 
WHERE gccrc in ('国家级人才A类', '国家级人才B类', '国家级人才C类', '省部级人才') 
AND xm_name like '*青年人才计划*'), 
(person)
-[:person_to_master*1..1]->
(student:/univ_demo/student_master)
-[:own_paper*1..1]->
(paper:/univ_demo/paper 
WHERE level in ('A类', 'B类') 
AND type in ('期刊', '会议') 
AND keywords like '*人工智能*') 
/**
output()
match("graph.edges.len",26,"graph.nodes.len",27)
**/
;