odbtools/odbctest/mql/uino/080.match.mql

MATCH 
(person:/zfdx_poc/hr_core_person_st)
-[:hr_core_person_st_to_hr_core_tech_duty_st*1..1]->
(tech_duty:/zfdx_poc/hr_core_tech_duty_st 
WHERE duty_level = '正高级' 
AND jj_time_start >= '2019-01-01 00:00:00' 
AND jj_time_start <= '2023-12-31 23:59:59'), 
(person:/zfdx_poc/hr_core_person_st)
-[:hr_core_person_st_to_hr_core_org_st*1..1]->
(org:/zfdx_poc/hr_core_org_st 
WHERE dept_sort_name = '教学科研' 
and name='民商经济法学院') 
RETURN person.account AS "account", 
person.name as "name", 
org.name AS "org_name", 
tech_duty.jj_time_start AS "promotion_year" 
WITH TIMEOUT = 6m
/**
output()
**/
;