Query history ( oracle database )

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 ,

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.

In Transactions table, the condition ObjectType= RT::Ticket and objectId =
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.Pletter@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