SV: [rt-users] Table relations in RT
Hilde T Lauvset Rafaelsen
hilde.rafaelsen at cc.uit.no
Thu Sep 1 05:44:07 EDT 2005
Where can I find this Perl API? Ant the other interfaces?
Hilde
-----Opprinnelig melding-----
Fra: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com]
Sendt: 1. september 2005 11:36
Til: Hilde T Lauvset Rafaelsen
Emne: Re: [rt-users] Table relations in RT
Specially for you there is Perl API that allow you to create tickets.
Also there is REST/Atom interfaces, mailgate and rt_cli.
On 9/1/05, Hilde T Lauvset Rafaelsen <hilde.rafaelsen at cc.uit.no> wrote:
> Hi,
>
> We want to have a registration form outside RT where users can
> registrate and report about problems. The reason we want this is
> because some users (we are at a university) use the phone instead of
> using RT and email.
>
> The info the user registrates in the application form is registrated
> in the RT database and will pop up as a new ticket in our main queue.
>
> I know it is not recommended to interact directly with the database,
> but the application form is strongly wanted from my leaders.
>
> Hilde
>
> -----Opprinnelig melding-----
> Fra: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com]
> Sendt: 31. august 2005 17:32
> Til: Hilde T Lauvset Rafaelsen
> Kopi: rt-users at lists.bestpractical.com
> Emne: Re: [rt-users] Table relations in RT
>
> On 8/31/05, Hilde T Lauvset Rafaelsen <hilde.rafaelsen at cc.uit.no>
wrote:
> > Hi,
> >
> > When a new Ticket is created in RT which tables are updated? Is a
> > new
> item insertet in Principals, CachedGroupMembers, GroupMembers and
> Groups every time a new ticket is created?
> Yes, RT always creates role groups while Ticket creation.
>
> >
> > I have looked at the RT database schema and tried to analyze the
> relation between all tables, but isn't 100% sure I understand
> everything. It would have been helpful if I could have looked at an
> insert example, but I don't know where all the insert, select and
> delete queries are hide in RT.
> >
> Did you see DBSchema on the wiki?
>
> > Hope anyone can help me here.
> I think no one can help you becuase we don't know what are you trying
> to do. Direct interactions with RT DB are not recommended. RT
> development process doesn't guaranty any compatibility of the DB
> schema in future versions. RT API is backward-compatible in most
cases.
>
> >
> > --
> > Hilde
> >
>
> --
> Best regards, Ruslan.
>
>
--
Best regards, Ruslan.
More information about the rt-users
mailing list