« Return to Thread: Reports
Re: Reports
by ptrthomas
::
Rate this Message:
Yes, the drop down values etc are configured in the "metadata" table linked to the space.
It is possible to get the kind of report you want by hard coding stuff in the query. You can see an example here:
http://sourceforge.net/tracker/index.php?func=detail&aid=2004890&group_id=162983&atid=825942
But I would recommend using the new XML API to generate the reports you want. The new XML output features are only available in the development build and you can find details here:
http://www.nabble.com/New-development-build-2.2.0-dev4-available-td18895697.html
If you need changes to the XML output to work better with BIRT let me know.
Thanks,
Peter.
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
-------------------------------------------------------------------------
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
| Free embeddable forum powered by Nabble | Forum Help |
