http://wiki.bestpractical.com/view/GetTicketInfoByWatcher
On 7/27/07, Christopher Moughan <[EMAIL PROTECTED]> wrote: > All I'm looking for is Real Name - Ticket ID - Subject - Time Worked - > Status. > > I just want to be able to print out a list of users and the tickets they > entered. > > > Thank you very much! > > 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. > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Ruslan Zakirov > Sent: Thursday, July 26, 2007 5:23 PM > To: Christopher Moughan > Cc: [email protected] > Subject: Re: [rt-users] Help with a query > > 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. > -- 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
