Transaction history :: where it is stored ? (RT 2.X, MySQL)

Hi.

I’ve search into the database (MySQL) and have not found.

I’m not finding any evidence of ‘transaction history’ in the file system.

I need to create a tickets view on our Intranet, so I’ll have to read
the ticket’s history.

Does anyone have any idea on where can I find further information on
where are ‘transaction histories’ stored ?

I just cannot find any help on wiki, user manual, etc …

Regards,
Jo�o Maca�ba.

Hi.

I’ve search into the database (MySQL) and have not found.

I’m not finding any evidence of ‘transaction history’ in the file system.

It’s definitely in the database. There is a transactions table that stores all of it. http://wiki.bestpractical.com/index.cgi?DBSchema

I need to create a tickets view on our Intranet, so I’ll have to read
the ticket’s history.

You really shouldn’t go directly to the database. Try using the RT API.

Michael
Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”