BiTel

SELECT * FROM register_task WHERE cid=XXX AND status IN (0, 1)

mysql> SELECT * FROM register_task WHERE cid=3964 AND status IN (0, 1);
+-------+------+------------+------+------+---------------------+----------+-----------+------------+---------------------+-----------+---------------------+--------+--------+-----------+---------------------+-----------------------------------------------------------------------------------------+----+------------+------+------------+
| id    | cid  | aobject_id | apid | type | open_dt             | open_uid | accept_dt | accept_uid | close_dt            | close_uid | lm_dt               | lm_uid | status | processed | target_dt           | comment                                                                                 | gr | resolution | prid | execute_dt |
+-------+------+------------+------+------+---------------------+----------+-----------+------------+---------------------+-----------+---------------------+--------+--------+-----------+---------------------+-----------------------------------------------------------------------------------------+----+------------+------+------------+
| 18901 | 3964 |          0 |   13 |    1 | 2012-06-19 20:01:58 |        0 | NULL      |        -10 | 2012-06-20 14:33:44 |         0 | 2012-06-20 14:29:18 |      5 |      0 |         0 | 2012-06-26 20:01:00 | Закрыто автоматически по отказу от подключения |  6 |            |    0 | NULL       |
+-------+------+------------+------+------+---------------------+----------+-----------+------------+---------------------+-----------+---------------------+--------+--------+-----------+---------------------+-----------------------------------------------------------------------------------------+----+------------+------+------------+
1 row in set (0.00 sec)

filter = new TaskFilter();
filter.cid = cid;
cnt = rtm.getTaskCount( filter );

public void closeAllTasks( cid )
{   

   //
   ctx = getContext();
   con = ctx.con;
   rtm = new RegisterTaskManager( con );

filter = new TaskFilter();
filter.cid = cid;
cnt = rtm.getTaskCount( filter );
print("getTaskCount="+cnt);
print("getNoClosedTaskList="+rtm.getNoClosedTaskList( cid ) );

   for ( RegisterTask task : rtm.getNoClosedTaskList( cid ) ) {

      print("task="+task);

      // закрываем очередную задачу
      task = closeTask( task, "Закрыто автоматически" );

      rtm.updateTask( task );

   }
}

public RegisterTask closeTask( RegisterTask task, String comment )
{
   CloseTaskDate = new java.util.Date();
      
   // закрываем задачу
   task.setCloseUserID( 0 );
   task.setCloseTime( CloseTaskDate );      
   task.setComment( comment );

   return task;
}

GENERATE_TIME: 20.06.12 15:37:08
EXECUTION_STOP_TIME: 20.06.12 15:37:08
PROCESS_TIME: 7

OUT:
getTaskCount=0
getNoClosedTaskList=[]