I've create a small
interface in PHP that submits a ticket to RT using the
rt-mailgate.
However, I've been
trying to pull data from the MySQL database so I don't have to constantly
create/manage user accounts in RT. This cusotmized interface pulls the basic
ticket info from the Tickets table fine. However, when I go to view the history
of the ticket it pulls random info from Attachments.
I understand that it
is more an object-oriented thing from Perl's DBI-builder that allows RT to
customize how it pulls data, but how should I go about constructing a MySQL
query to pull all data on a particular ticket based on the Ticekts.id and
Tickets.EffectiveId?
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
