Re: [jtrac-users] Reports

[Steven J. <Ste...@th...>]

I am out of the office.  If you require immediate assistance, please
contact Patrick Wong at x5891.

Thank you.



>>> j-trac-users 09/01/08 23:49 >>>

Hi one and all,

 

I'm playing around with eclipse and BIRT to create some custom reports
for
JTRAC, as I need to get some idea of open/closure rates for tickets over
the
week/month.

 

My 2.1.0 JTRAC installation is running from mysql and I can view all
tables
etc from my eclipse environment and BIRT, so all good so far.

 

The question that I have is to do with the schema.

 

In what table are the custom field labels and the dropdown field values
stored?   For the life of me I have looked in all tables and can't find
any
reference to the custom field data.  Obviously In the Items table I can
see
the custom fields and their values, but no other referenced tables.

 

Regards,

 

Stephen.

 

 

 

 


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law.  If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure.  If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited.  Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.