[rt-users] Table relations in RT

[Ruslan Zakirov]

Please, search lists archive for "form", "create ticket" and other
keywords. There were several solutions posted and also described how
to use different RT interfaces.

RT also has wiki with a lot of useful documentation and contributions.


On 9/1/05, Hilde T Lauvset Rafaelsen <hilde.rafaelsen at cc.uit.no> wrote:
> 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.
> 
> 


-- 
Best regards, Ruslan.