[rt-users] change/modify tickets

Rich Lafferty rich+rt at lafferty.ca
Wed Jan 29 21:05:01 EST 2003

On Wed, Jan 29, 2003 at 07:43:58PM -0600, Sergio Cesar <sergio at winc.net> wrote:
> Thanks, got it.
> If any one knows of a script or a way to actually edit the content I would
> be very much interested.
> As a newbie to RT I don't feel yet comfortable with the database schema, but
> if someone could hint me what are the tables/fields I need to edit and some
> warning what not to touch I may venture a perl script to do so... :)

That's easy: Don't touch the database; touch the API. :-) 

I've done a lot of small to medium modifications to RT here -- my
RT rpm has 48 patches now! -- and I've never needed to touch the
database outside the API, except for incrementing the ticket counter
for ticket numbering by date.

The API is documented in perldoc, so 

   export PERL5LIB /opt/rt2/lib
   perldoc RT::Ticket

and so forth, and look at existing code (such as the stuff in
WebRT/html/ and in bin/) to oget a start as to what's what.



Rich Lafferty --------------+-----------------------------------------------
 Ottawa, Ontario, Canada    |  Save the Pacific Northwest Tree Octopus!
 http://www.lafferty.ca/    |    http://zapatopi.net/treeoctopus.html
rich at lafferty.ca -----------+-----------------------------------------------

More information about the rt-users mailing list