[rt-users] transaction history :: where it is stored ? (RT 2.X, MySQL)

[Michael S. Liebman]

On Fri, May 13, 2005 at 04:27:06PM -0300, Joao Macaiba wrote:
> 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 at 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"