|

Reports

View: New views

4 Messages — Rating Filter: Alert me

	Reports by Stephen Eaton :: Rate this Message: Reply to Author \| View Threaded \| Show Only 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
	Re: Reports by ptrthomas :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Stephen, 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. On Tue, Sep 2, 2008 at 9:19 AM, Stephen Eaton <seaton@...> wrote: 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
	Re: Reports by Stephen Eaton :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Thanks for that Peter, whilst poking around in the tables late last night I found the values hidden with an XML field, so I have had to resort to hard coding values in my reports atm. I will look at the dev build and see how things work with BIRT. I knwo that Birt will look at an XML file as a data source. From reading the features link I guess I need to export the XML data first from JTRAC? my requirements are more for managers who don't like doing those sort of things other than clicking on a report, anyway I'll install the current build and have a play around. Can the XML export function have a web service wrapped around it ? i.e. soap, this would definately solve most of my issues as BIRT appears to be able to look at web service data sources. Regards, Stephen... From: j-trac-users-bounces@... [mailto:j-trac-users-bounces@...] On Behalf Of Peter Thomas Sent: Wednesday, 3 September 2008 3:19 AM To: JTrac users mailing-list Subject: Re: [jtrac-users] Reports Stephen, 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. On Tue, Sep 2, 2008 at 9:19 AM, Stephen Eaton <seaton@...> wrote: 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 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
	Re: Reports by Stephen Eaton :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Doh! I did't read the remote API side of things! <blush> sorry had a bloke look as my wife would say! Stephen.... From: j-trac-users-bounces@... [mailto:j-trac-users-bounces@...] On Behalf Of Stephen Eaton Sent: Wednesday, 3 September 2008 11:21 AM To: 'JTrac users mailing-list' Subject: Re: [jtrac-users] Reports Thanks for that Peter, whilst poking around in the tables late last night I found the values hidden with an XML field, so I have had to resort to hard coding values in my reports atm. I will look at the dev build and see how things work with BIRT. I knwo that Birt will look at an XML file as a data source. From reading the features link I guess I need to export the XML data first from JTRAC? my requirements are more for managers who don't like doing those sort of things other than clicking on a report, anyway I'll install the current build and have a play around. Can the XML export function have a web service wrapped around it ? i.e. soap, this would definately solve most of my issues as BIRT appears to be able to look at web service data sources. Regards, Stephen... From: j-trac-users-bounces@... [mailto:j-trac-users-bounces@...] On Behalf Of Peter Thomas Sent: Wednesday, 3 September 2008 3:19 AM To: JTrac users mailing-list Subject: Re: [jtrac-users] Reports Stephen, 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. On Tue, Sep 2, 2008 at 9:19 AM, Stephen Eaton <seaton@...> wrote: 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 __________ Information from ESET Smart Security, version of virus signature database 3409 (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 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