{
"keyColumn": "task_id",
"wildsearch": "true",
"detailHeaderColumnPrefix": "Team: ",
"handleFile": "true",
"detailHeaderColumns": [
"module_id"
],
"breadCrumbColumn": "module_id",
"orderBy": {
"task_id": "DESC"
},
"listColumns": [
"module_id",
"task_owner",
"created_by",
"task_title",
"task_description",
"task_estimated_time",
"task_estimated_completion_date",
"hold"
],
"showColumns": [
"task_id",
"module_id",
"task_owner",
"created_by",
"task_title",
"task_description",
"task_estimated_time",
"task_estimated_completion_date",
"hold"
],
"detailColumns": [
"task_id",
"module_id",
"task_owner",
"created_by",
"task_title",
"task_description",
"task_estimated_time",
"task_estimated_completion_date",
"hold"
],
"columns": {
"task_id": {
"name": "ID",
"editoptions": {
"type": "hidden"
}
},
"module_id": {
"name": "Module",
"searchable": "true",
"sortable": "true",
"external": "true",
"externalOptions": {
"externalTable": "tbl_project_module",
"externalColumn": "module_id",
"externalShowColumn": "module_title"
}
},
"task_owner": {
"name": "assigned to",
"searchable": "true",
"sortable": "true",
"external": "true",
"externalOptions": {
"externalTable": "tbl_employee",
"externalColumn": "emp_main_id",
"externalShowColumn": "first_name"
},
"editoptions": {
"type": "select",
"source": "Cmshelper::getProjectTeamUsernameCombo",
"default": "",
"source_type": "function",
"label": "Assigned to",
"class": "select hidden_field"
}
},
"created_by": {
"name": "assigned by",
"searchable": "true",
"sortable": "true",
"external": "true",
"externalOptions": {
"externalTable": "tbl_employee",
"externalColumn": "emp_main_id",
"externalShowColumn": "first_name"
}
},
"task_title": {
"name": "Title",
"searchable": "true",
"sortable": "true",
"editoptions": {
"type": "textbox",
"label": "Task Title",
"class": "textbox hidden_field",
"hint": "project Title",
"validations": [
"required"
]
}
},
"task_estimated_completion_date": {
"name": "Task Completion Date",
"dbFormat": "date",
"displayFormat": "m/d/Y",
"editoptions": {
"dbFormat": "date",
"displayFormat": "m/d/Y",
"type": "datepicker",
"label": "Task Completion Date",
"class": "",
"hint": "Task Completion Date",
"validations": [
"required"
]
}
},
"task_estimated_time": {
"name": "Estimated Time",
"searchable": "true",
"sortable": "true",
"editoptions": {
"type": "textbox",
"label": "Task Estimated Time",
"class": "textbox hidden_field",
"hint": "Estimated Time",
"validations": [
"required",
"numeric"
]
}
},
"task_description": {
"name": "Description",
"searchable": "true",
"sortable": "true",
"editoptions": {
"type": "textarea",
"label": "Description",
"class": "textbox hidden_field",
"hint": "project Title",
"validations": [
"required"
]
}
},

"hold": {
"name": "Hold",
"sortable": "true",

"editoptions": {
"type": "checkbox",
"label": "Hold",
"class": "inline",
"default": "0",
"enumvalues": {
"0": "",
"1": "On Hold"
}
}
}
},
"relations": {
"Logs": {
"name": "Logs",
"section": "project_task_logs",
"child_table": "tbl_project_task_logs",
"parent_join_column": "task_id",
"child_join_column": "task_id"
}
},
"reference": {
"referenceTable": "tbl_project_module",
"referenceColumn": "module_id",
"referenceTableForiegnKey": "module_id"
},
"customActions": {
"beforeAddRecord": "Cmshelper::validateEngine",
"afterAddRecord": "Cmshelper::increaseTaskCount",
"beforeDeleteRecord": "Cmshelper::decreaseTaskCount",
"beforeEditRecord": "Cmshelper::updateTaskTime"
},
"opertations": [
"add",
"edit",
"view",
"delete"
],
"operationLabel": {
"addLabel": "Add Task",
"editTitle": "Hold Task",
"viewTitle": "View Task Details",
"deleteTitle": "Delete Task"
}
}