[jtrac-users] Reports

[Stephen E. <se...@ga...>]

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.