{
"matrixName": "分部矩阵",
"matrixViewName": "matrix_table_2",
"matrixColumnMap": {
"多人员2":"drl2",
"多人员3":"drl3",
"多人员1":"dry1",
"单人员1":"drl1"
}
}
curl --location --request POST '/api/hrm/restful/buildMatrixView' \
--header 'Content-Type: application/json' \
--data-raw '{
"matrixName": "分部矩阵",
"matrixViewName": "matrix_table_2",
"matrixColumnMap": {
"多人员2":"drl2",
"多人员3":"drl3",
"多人员1":"dry1",
"单人员1":"drl1"
}
}'
{
"message": {
"errcode": "0",
"errmsg": "success"
},
"data": "create view matrix_table_2 as select d.id as id,d.disporder as dataorder,drl2.relate_id as drl2,drl3.relate_id as drl3,dry1.relate_id as dry1,drl1.relate_id as drl1 from eteams.department d left join (select GROUP_CONCAT(relate_id SEPARATOR ',') as relate_id,matrix_data_id from eteams.hrm_matrix_value_data where TENANT_KEY ='tx32g1i3bj' and delete_type =0 and matrix_value_config_id=894539497695936514 group by matrix_data_id ) drl2 on d.id=drl2.matrix_data_id left join (select GROUP_CONCAT(relate_id SEPARATOR ',') as relate_id,matrix_data_id from eteams.hrm_matrix_value_data where TENANT_KEY ='tx32g1i3bj' and delete_type =0 and matrix_value_config_id=923184979570761730 group by matrix_data_id ) drl3 on d.id=drl3.matrix_data_id left join (select GROUP_CONCAT(relate_id SEPARATOR ',') as relate_id,matrix_data_id from eteams.hrm_matrix_value_data where TENANT_KEY ='tx32g1i3bj' and delete_type =0 and matrix_value_config_id=894539497695936513 group by matrix_data_id ) dry1 on d.id=dry1.matrix_data_id left join (select GROUP_CONCAT(relate_id SEPARATOR ',') as relate_id,matrix_data_id from eteams.hrm_matrix_value_data where TENANT_KEY ='tx32g1i3bj' and delete_type =0 and matrix_value_config_id=894539497695936512 group by matrix_data_id ) drl1 on d.id=drl1.matrix_data_id where d.TENANT_KEY = 'tx32g1i3bj' and d.type ='subcompany' and d.IS_DELETE ='0' and d.STATUS ='1' "
}