[rt-users] Help with a query

[Ruslan Zakirov]

http://wiki.bestpractical.com/view/GetTicketInfoByWatcher


On 7/27/07, Christopher Moughan <cmoughan at bbinslv.com> 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: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On
> Behalf Of Ruslan Zakirov
> Sent: Thursday, July 26, 2007 5:23 PM
> To: Christopher Moughan
> Cc: rt-users at lists.bestpractical.com
> 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 <cmoughan at bbinslv.com> 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: sales at bestpractical.com
> >
> >
> > 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.