si marco el estado de un ticket como "pending auto close +/-" y le asigno una fecha, llegada esta fecha el ticket no se cierra, y sigue marcado como pendiente.
Esto pasa tanto si el ticket está o no bloqueado, y sea cual sea la cola.
Como estuve tocando los nombres de los estados y tal,comentar que "pending auto close +" corresponde a un tipo "pending auto":
Code: Select all
mysql> select * from ticket_state where name like 'pending%';
+----+---------------------+----------------------------------------+---------+----------+---------------------+-----------+---------------------+-----------+
| id | name | comments | type_id | valid_id | create_time | create_by | change_time | change_by |
+----+---------------------+----------------------------------------+---------+----------+---------------------+-----------+---------------------+-----------+
| 7 | pending auto close+ | Ticket is pending for automatic close. | 5 | 1 | 2012-02-16 09:59:30 | 1 | 2012-03-20 11:04:29 | 3 |
| 8 | pending auto close- | Ticket is pending for automatic close. | 5 | 1 | 2012-02-16 09:59:30 | 1 | 2012-03-20 11:04:11 | 3 |
| 6 | pending reminder | Ticket is pending for agent reminder. | 4 | 1 | 2012-02-16 09:59:30 | 1 | 2012-03-20 11:03:04 | 3 |
+----+---------------------+----------------------------------------+---------+----------+---------------------+-----------+---------------------+-----------+
Code: Select all
mysql> select * from ticket_state_type where id=5;
+----+--------------+-------------------------------------------------------+---------------------+-----------+---------------------+-----------+
| id | name | comments | create_time | create_by | change_time | change_by |
+----+--------------+-------------------------------------------------------+---------------------+-----------+---------------------+-----------+
| 5 | pending auto | All 'pending auto *' state types (default: viewable). | 2012-02-16 09:59:30 | 1 | 2012-02-16 09:59:30 | 1 |
+----+--------------+-------------------------------------------------------+---------------------+-----------+---------------------+-----------+
1 row in set (0.00 sec)
Gracias.