-
- $result = db_query_params ('SELECT project_task_vw.*, project_task_external_order.external_id
- FROM project_task_vw natural left join project_task_external_order, project_assigned_to
- WHERE project_task_vw.project_task_id=project_assigned_to.project_task_id
- AND project_task_vw.group_project_id = $1
- AND project_assigned_to.assigned_to_id = ANY ($2)' . $order,
- array ($this->ProjectGroup->getID(),
- db_int_array_to_any_clause ($tat)),
- $this->max_rows,
- $this->offset) ;
+ $qpa = db_construct_qpa($qpa, 'SELECT project_task_vw.*, project_task_external_order.external_id
+ FROM project_task_vw natural left join project_task_external_order, project_assigned_to
+ WHERE project_task_vw.project_task_id = project_assigned_to.project_task_id ');
+ $qpa = db_construct_qpa($qpa, 'AND project_task_vw.group_project_id = $1 AND project_assigned_to.assigned_to_id = ANY ($2) ',
+ array ($this->ProjectGroup->getID(), db_int_array_to_any_clause ($tat)));