[rt-users] Database tables...

[Brandon S. Allbery KF8NH]

On Tuesday, February 13, 2001 20:34:51 -0500, "Steven J. Sobol" 
<sjsobol at NorthShoreTechnologies.net> wrote:
+-----
| I'm creating a search page that will search RT tickets. It currently
| searches in the keywords and subject fields from each_req. I would like to
| know where the comments and correspondence are stored so I can search
| those fields too.
+--->8

Howdy stranger :)

If RT is installed in /home/rt, transaction text is found in 
/home/rt/transactions/(year)/(month)/(day)/(serial_num).(transaction_id).

-- 
brandon s. allbery     [os/2][linux][solaris][japh]   allbery at kf8nh.apk.net
system administrator        [WAY too many hats]         allbery at ece.cmu.edu
electrical and computer engineering                                   KF8NH
carnegie mellon university     ["better check the oblivious first" -ke6sls]