-- 拼接教育信息可以参考如下：
SELECT
person_education.person_id,
edu_method.code AS edu_method_code,
-- 全日制学历学位
string_agg(irt_edu_background.value || ' ' || irt_academic_degree.value,'|') as education_background_info,
-- 全日制毕业院校及专业
string_agg(person_education.school || ' '|| person_education.profession,'|') as school_profession
FROM cadre_person_education person_education
LEFT JOIN res_selection AS edu_method ON person_education.study_method = edu_method.id
LEFT JOIN res_selection AS edu_background ON person_education.educational_background = edu_background.id
LEFT JOIN res_selection AS academic_degree ON person_education.academic_degree = academic_degree.id
LEFT JOIN ir_translation AS irt_edu_background ON irt_edu_background.res_id = edu_background.id and irt_edu_background.lang='zh_CN' and irt_edu_background.name='res.selection,name'
LEFT JOIN ir_translation AS irt_academic_degree ON irt_academic_degree.res_id = academic_degree.id and irt_academic_degree.lang='zh_CN' and irt_academic_degree.name='res.selection,name'
GROUP BY person_education.person_id,edu_method.code
Change
Medium
