[rt-users] Making batch changes to ticket ownership

Drew Barnes barnesaw at ucrwcu.rwc.uc.edu
Wed Dec 14 14:12:58 EST 2005


- Do a query to get all of his/her tickets.
- Bulk update the owner

Paul Crossman wrote:
> I've search the archives on this and came up empty on something close to
> this.  
>
> I've found this
> (http://wiki.bestpractical.com/index.cgi?TransactionBatchStage) in the Wiki,
> but I'm not quite sure it's what I want.  See below.
>
> We've had someone leave the company recently that has a couple hundred
> tickets we'd like to transfer ownership to a different user.  
>
> Is there a simple way to perform this task in batch through the web
> interface or does this have to be done with SQL to the database?  
>
> SQL statements to the database would not show the ticket transfer from one
> user to another, but I'm not sure if that's a concern of the users at this
> point.
>
> We're running RT 3.4.2 on MySQL 4.1.
>
> Paul C.
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
>
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
>   

-- 
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati




More information about the rt-users mailing list