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