月度人员调动信息表sql如下-可以通过参数query_month筛选: with selection_json as (SELECT jsonb_object_agg(res_id,value) selection_json from ir_translation where name='res.selection,name' and lang='zh_CN') select emp.employee_number 员工工号, emp.name 姓名, selection_json.selection_json->>emp_job.x_czlx::varchar 操作类型, coalesce(employee_type_trans.value,employee_type.name) 员工类型, emp_job.start_date 本记录开始日期, emp_job.end_date 本记录结束日期, selection_json.selection_json->>emp_job.x_ywtx::varchar 业务条线, coalesce(bu_trans.value,bu.name) 所属业务单元, coalesce(hr_department_trans.value,hr_department.name) 部门, coalesce(hr_position_trans.value,hr_position.name) 岗位, selection_json.selection_json->>emp_job.x_qzht::varchar 前中后台, x_builder_zxl.x_zxl 子序列, x_builder_4jgw.x_4jgw 四级岗位, x_builder_wjgw.x_wjgw 五级岗位, manager_emp.name 直接上级 from emp_job left join hr_employee emp on emp_job.employee_id=emp.id left join selection_json on 1=1 left join employee_type on emp_job.employee_type=employee_type.id left join ir_translation employee_type_trans on employee_type_trans.res_id=employee_type.id and employee_type_trans.name ='employee.type,name' and employee_type_trans.lang='zh_CN' LEFT JOIN hr_business_unit AS bu ON emp_job.business_unit_id = bu.id left join ir_translation bu_trans on bu_trans.res_id=bu.id and bu_trans.name ='hr.business.unit,name' and bu_trans.lang='zh_CN' left join hr_department on emp_job.department_id=hr_department.id left join ir_translation hr_department_trans on hr_department_trans.res_id=hr_department.id and hr_department_trans.name ='hr.department,name' and hr_department_trans.lang='zh_CN' left join hr_position on emp_job.position_id=hr_position.id left join ir_translation hr_position_trans on hr_position_trans.res_id=hr_position.id and hr_position_trans.name ='hr.position,name' and hr_position_trans.lang='zh_CN' left join x_builder_zxl on emp_job.x_zxl=x_builder_zxl.id left join x_builder_4jgw on emp_job.x_4jgw=x_builder_4jgw.id left join x_builder_wjgw on emp_job.x_5jgw=x_builder_wjgw.id left join hr_employee manager_emp on emp_job.manager_employee_id=manager_emp.id where to_char(emp_job.start_date,'yyyy-mm')='${query_month:2021-12}'