we don't recommend using pure SQL within RT's DB to do any
manipulations, even for reports we suggest API, but anyway you should
ask more specific questions to get answer, for example "how to select
all watchers of a ticket with id X?" or something like that.
On 7/26/07, Christopher Moughan <[EMAIL PROTECTED]> wrote:
Hey all,
I apologize if this is the wrong forum for this, but is there anyone willing
to share a query or two with me. I know absolutely nothing about MySQL
queries. (I did how ever just order a book). I am looking for generic simple
queries. Ticket ID, User, Subject, Time worked, Status. I have MySQL Query
Builder can't seem to get the tables to join properly. My RT DB installation
is default, no mods to tables or anything. ANY help is appreciated.
Thanks
Christopher Moughan
System Administrator
Brown & Brown Lehigh Valley
268 Brodhead Road
Bethlehem, PA 18017
Office 610-694-1814
Fax 610-974-9791
IMPORTANT: Insurance coverage can not be bound, amended or changed via
voicemail, facsimile or Email message without confirmation from an
authorized Brown & Brown representative.
NOTICE: The information contained in this electronic message is legally
privileged and confidential and is intended for the use of the individual or
entity named above. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copy of this message is strictly prohibited. If you have received this
communication in error, please contact the sender by reply email and destroy
all electronic and printed copies of this message.
_______________________________________________
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
--
Best regards, Ruslan.
_______________________________________________
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
