举例：人员信息管理list层关联出 教育经历子集是全日制教育那条数据的的学历字段信息
查看此子集的参数返回值(即教育经历是全日制教育这条)
1.配置relations
{
"relations":[ {
"filter": {
"education_new.employee_id": ":id", #关联模型下employee_id等于当前表下id字段 其中：代表当前表
"education_new.education_form": "全日制教育" #关联过滤条件在filter中定义
},
"model": "EmployeeEducation", #关联模型
"type": "outer", #关联方式内连接、外链接
"key": "education_new" #关联模型别名、相当于关联模型的唯一标识
}]
2、配置fields显示此字段
"fields":[{
"label": "学历",
"sequence": 240,
"width": "col-6",
"field": ["education_new","education"], #定位信息、定位到关联模型education_new下的education字段
"key": "education_name",
"hide": false
}]
}
常用的标准关联：
根据人员关联当前任职以及单位部门和岗位、序列、职级、政治面貌、最高教育经历等等
{ "relations": [
{
"filter": {
"job_info.position_type": [
1,
2
],
"job_info.end_date": {
"gt": "=date_"
},
"job_info.employee_id": ":id",
"job_info.begin_date": {
"lte": "=date_"
}
},
"model": "JobInformation",
"name": "任职信息",
"key": "job_info"
},
{
"filter": {
"job_info.position_id": ":position.origin_id",
"position.begin_date": {
"lte": "=date_"
},
"position.end_date": {
"gt": "=date_"
}
},
"model": "OrgPositionHistory",
"type": "outer",
"name": "岗位信息",
"key": "position",
"blur": [
"name"
]
},
{
"filter": {
"position.parent_id": ":department.origin_id",
"department.begin_date": {
"lte": "=date_"
},
"department.end_date": {
"gt": "=date_"
}
},
"model": "OrgDepartmentHistory",
"type": "outer",
"name": "部门信息",
"key": "department"
},
{
"filter": {
"department.subordinate_unit_id": ":unit.origin_id",
"unit.begin_date": {
"lte": "=date_"
},
"unit.end_date": {
"gt": "=date_"
}
},
"model": "OrgUnitHistory",
"type": "outer",
"name": "单位信息",
"key": "unit"
},
{
"filter": {
"job_info.job_step_id": ":job_step.id"
},
"model": "JobStep",
"type": "outer",
"name": "职级",
"key": "job_step"
},
{
"filter": {
"job_step.step_type_id": ":position_sequence.id"
},
"model": "JobStepType",
"type": "outer",
"name": "序列",
"key": "position_sequence"
},
{
"filter": {
"latest_political_landscape.employee_id": ":id",
"latest_political_landscape.is_latest": "1"
},
"model": "EmployeePoliticalLandscape",
"type": "outer",
"name": "最新政治面貌",
"key": "latest_political_landscape"
},
{
"filter": {
"highest_education.employee_id": ":id",
"highest_education.is_highest": "1"
},
"model": "EmployeeEducation",
"type": "outer",
"name": "最高学历",
"key": "highest_education"
}
]}