In Transactions table, the condition ObjectType= RT::Ticket and objectId = <ticketId> will give you the transactions for the ticket. The contents of those transactions will be available from Attachments table.
On Mon, Oct 17, 2016 at 1:32 PM, Pletter Thomas <t.plet...@rewe-group.at> wrote: > Hello, > > Our repository is stored in a oracle database. > > In which column is the history of a ticket stored ? > > I find *<https://rt-wiki.bestpractical.com/wiki/Schema > <https://rt-wiki.bestpractical.com/wiki/Schema>>* , > > Is it the Table transactions, Column data ? In Column objectid is the > ticket id stored . > When I query the table transactions, I can’t get the total history of one > ticket. > > Kind regards, > Tom > ______________________________________ > > HINWEIS: > Alle von Gesellschaften der REWE International AG elektronisch > uebermittelten Auskuenfte, Mitteilungen > und Erklaerungen sind vertraulich und rechtlich unverbindlich. > Verpflichtungen von Gesellschaften der > REWE International AG beduerfen der schriftlichen Einigung in saemtlichen > Vertragspunkten sowie der Unterfertigung > durch das vertretungsbefugte Organ. Im Falle einer Fehluebermittlung > ersuchen wir um Benachrichtigung sowie um > Vernichtung und Beachtung, dass jegliche Form der Verwendung und > Weitergabe der Inhalte an Dritte unzulaessig ist. > > NOTICE: > All notices, declarations and explanations transferred electronically from > REWE International AG companies > are confidential and not legally binding. Obligations of REWE > International AG companies arise only when written > agreement to all contractual points has been confirmed in writing with the > signature of an authorized representative. > If this e-mail was sent by mistake, please inform us immediately. > Furthermore we also request you to destroy it > and use neither the contents nor disclose them in any manner to third > parties. > > > --------- > RT 4.4 and RTIR training sessions, and a new workshop day! > https://bestpractical.com/training > * Boston - October 24-26 > * Los Angeles - Q1 2017 >
--------- RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Boston - October 24-26 * Los Angeles - Q1 2017
