[rt-users] Query history ( oracle database )

[aniket tripathy]

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.Pletter at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20161017/1ba217a9/attachment.htm>