Mass Close in Eventum?

Is there a way to do a mass close of all issues?

With the new year, we need to start fresh, and I'm not
really sure if
this is something I'll have to do by hand or what...


Thanks!
Robert Minick
Fifth Third Bank


This e-mail transmission contains information that is
confidential and may be privileged.   It is intended only
for the addressee(s) named above. If you receive this e-mail
in error, please do not read, copy or disseminate it in any
manner. If you are not the intended recipient, any
disclosure, copying, distribution or use of the contents of
this information is prohibited. Please reply to the message
immediately by informing the sender that the message was
misdirected. After replying, please erase it from your
computer system. Your assistance in correcting this error is
appreciated.

--
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe:    http:
//lists.mysql.com/eventum-users?unsub=bondyahoo.com

Here is what I have figured out in SQL --


UPDATE `eventum_issue` SET `iss_sta_id` = '9', `iss_res_id`
= '2',
`iss_last_public_action_date` = NOW(),
`iss_last_public_action_type` =
'closed', `iss_last_internal_action_date` = NOW(),
`iss_last_internal_action_type` = 'note' WHERE
`eventum_issue`.`iss_id`
= 201 LIMIT 1;



I want to close a bunch of them all at once.  I know that
the WHERE
clause is where I'm getting hung up, but unfortunately I
don't know SQL
all that well.  I want to close tickets 201 - 561 in one
run.  Any ideas
how that can be done?

Thanks for any help!

Robert Minick

This e-mail transmission contains information that is
confidential and may be privileged.   It is intended only
for the addressee(s) named above. If you receive this e-mail
in error, please do not read, copy or disseminate it in any
manner. If you are not the intended recipient, any
disclosure, copying, distribution or use of the contents of
this information is prohibited. Please reply to the message
immediately by informing the sender that the message was
misdirected. After replying, please erase it from your
computer system. Your assistance in correcting this error is
appreciated.

--
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe:    http:
//lists.mysql.com/eventum-users?unsub=bondyahoo.com