[rt-users] Help with a query

[Ruslan Zakirov]

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.