Changeset 3160 for trunk/workflow/inc/local
- Timestamp:
- 08/16/10 17:19:14 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/workflow/inc/local/classes/class.wf_instance.php
r2832 r3160 267 267 268 268 /* build the SQL query */ 269 $query = 'SELECT i.wf_instance_id AS wf_instance_id, ' . 270 ' ia.wf_activity_id AS wf_activity_id, ' . 271 ' i.wf_started AS wf_started, ' . 272 ' i.wf_name AS wf_name, ' . 273 ' i.wf_status AS wf_status, ' . 274 ' ia.wf_user AS wf_user, ' . 275 ' ir.wf_parent_lock AS wf_parent_lock ' . 276 ' FROM egw_wf_interinstance_relations ir, egw_wf_instances i ' . 277 ' LEFT JOIN egw_wf_instance_activities ia ' . 278 ' ON (ia.wf_instance_id = i.wf_instance_id) ' . 279 ' WHERE ' . 280 ' (ir.wf_child_instance_id = i.wf_instance_id) AND (ir.wf_parent_instance_id = ?) '; 269 $query = " 270 SELECT 271 i.wf_instance_id AS wf_instance_id, 272 ia.wf_activity_id AS wf_activity_id, 273 i.wf_started AS wf_started, 274 i.wf_name AS wf_name, 275 i.wf_status AS wf_status, 276 ia.wf_user AS wf_user, 277 ir.wf_parent_lock AS wf_parent_lock 278 FROM 279 egw_wf_interinstance_relations as ir 280 LEFT JOIN 281 egw_wf_instances as i 282 ON 283 i.wf_instance_id = ir.wf_parent_instance_id 284 LEFT JOIN 285 egw_wf_instance_activities as ia 286 ON 287 i.wf_instance_id = ia.wf_instance_id 288 WHERE 289 i.wf_instance_id = ?"; 281 290 282 291 $result = $this->db->query($query, array($instanceID));
Note: See TracChangeset
for help on using the changeset viewer.