« Return to Thread: Reports

Reports

by Stephen Eaton :: Rate this Message:

Some parts of this message have been removed. Learn more about Nabble's security policy.

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…

__________ Information from ESET Smart Security, version of virus signature database 3406 (20080902) __________

The message was checked by ESET Smart Security.

http://www.eset.com

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
j-trac-users mailing list
j-trac-users@...
https://lists.sourceforge.net/lists/listinfo/j-trac-users

« Return to Thread: Reports