Mailing List Archive

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.
Re: Query history ( oracle database ) [ In reply to ]
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@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
>