[rt-users] Help with a query

[Christopher Moughan]

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. 

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070726/e906c816/attachment.htm>