Help with a query

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.

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@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.


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.

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


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.