{
"keyColumn": "team_id",
"wildsearch": "true",
"detailHeaderColumnPrefix": "Team: ",
"handleFile": "true",
"detailHeaderColumns": [
"project_id"
],
"breadCrumbColumn": "project_id",
"orderBy": {
"team_id": "DESC"
},
"listColumns": [
"project_id",
"user_id"
],
"showColumns": [
"team_id",
"project_id",
"user_id"
],
"detailColumns": [
"team_id",
"project_id",
"user_id",
"added_to_gitlab"
],
"columns": {
"team_id": {
"name": "ID",
"editoptions": {
"type": "hidden"
}
},
"project_id": {
"name": "Project",
"searchable": "true",
"sortable": "true",
"external": "true",
"externalOptions": {
"externalTable": "tbl_projects",
"externalColumn": "project_id",
"externalShowColumn": "project_title"
}
},
"added_to_gitlab": {
"name": "Add to GitLab",
"editoptions": {
"type": "checkbox",
"label": "Add to GitLab",
"class": "inline",
"default": "0",
"enumvalues": {
"0": "No",
"1": "Yes"
}
}
},
"user_id": {
"name": "Team Member",
"searchable": "true",
"sortable": "true",
"external": "true",
"externalOptions": {
"externalTable": "tbl_employee",
"externalColumn": "emp_main_id",
"externalShowColumn": "first_name"
},
"editoptions": {
"type": "select",
"source": "Cmshelper::getUsernameCombo",
"default": "",
"source_type": "function",
"label": "Team Member",
"class": "select",
"validations": [
"required"
]
}
}
},
"reference": {
"referenceTable": "tbl_projects",
"referenceColumn": "project_id",
"referenceTableForiegnKey": "project_id"
},
"customActions": {
"afterAddRecord": "Cmshelper::increaseTeamCount",
"beforeDeleteRecord": "Cmshelper::decreaseTeamCount",
"beforeAddRecord": "Cmshelper::checkAlreadyMember",
"beforeEditRecord": "Cmshelper::checkAlreadyMember"
},
"opertations": [
"add",
"view",
"edit",
"delete"
],
"operationLabel": {
"addLabel": "Add Team Member",
"editTitle": "Edit Team Member",
"viewTitle": "View Team Details",
"deleteTitle": "Delete Team Member"
}
}