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?
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.
Hope anyone can help me here.
Hilde
Hilde Therese Lauvset Rafaelsen
IT-avdelingen, Universitetet i Tromsø
Tlf: +47 77 64 58 01
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.
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@cc.uit.no wrote:
Where can I find this Perl API? Ant the other interfaces?
Hilde
-----Opprinnelig melding-----
Fra: Ruslan Zakirov [mailto:ruslan.zakirov@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@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@gmail.com]
Sendt: 31. august 2005 17:32
Til: Hilde T Lauvset Rafaelsen
Kopi: rt-users@lists.bestpractical.com
Emne: Re: [rt-users] Table relations in RT
On 8/31/05, Hilde T Lauvset Rafaelsen hilde.rafaelsen@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.