[rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]

[Alex Rhys-Hurn]

wow! Awesome. 

I am going to try this immediately. 

Thanks so much for the quick reply too. 

Alex 

----- Original Message -----

From: "Benjamin Boksa" <mailinglists at boksa.de> 
To: "Alex Rhys-Hurn" <alex at itworx.co.ke> 
Sent: Friday, 27 April, 2012 1:24:03 PM 
Subject: Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)] 


Hi Alex, 


the cool thing about my integration toolkit is, that it does not use SQL at all. It uses the REST Interface (see "Ticket Search") described here: 


http://requesttracker.wikia.com/wiki/REST 


Among other data you get the "TimeWorked" field already calculated ;-) 


The Queries used in Jasper are written in RTRIQL which itself is a superset of the Query Builder Query Language (which means you can use any Query Builder query from RT you already have). 


Looking forward to you feedback 


Benjamin 






Am 27.04.2012 um 12:09 schrieb Alex Rhys-Hurn: 




Dear Benjamin, 

Thanks for all the hard work. 

I have in fact played with Jasper and RT before. 

I gave up as the reports I was trying to generate were to do with time worked. 

RT seems to have two different places where time is recorded and calculated, and so querying the DB gets complicated. 

Does your integration of Jasper with RT make this clearer / easier? 

or do you have any example SQL queries for reporting on Time worked in RT? 

Thanks so much, 

Alex 

----- Original Message -----

From: "Benjamin Boksa" < mailinglists at boksa.de > 
To: "Albert Shih" < Albert.Shih at obspm.fr > 
Cc: rt-users at lists.bestpractical.com 
Sent: Thursday, 26 April, 2012 10:59:37 PM 
Subject: Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)] 

Hi Albert, 

you can generate any kind of reports supported by JasperReports Server. RT-Jasper provides the DataSource necessary to query RT for tickets (the ticket's data can be used in the reports). 

Regarding your questions: 

1) See the private mail I sent you. 
2) No. 

If you have further questions just let me know. 

Greetings from Cologne 

Benjamin 




Am 26.04.2012 um 21:28 schrieb Albert Shih: 

> Le 22/04/2012 ? 19:11:23+0200, Benjamin Boksa a écrit 
> Hi. 
> 
>> 
>> it's done :-) I have setup two GitHub repositories to host everything you need to run you own RT an JasperReports Server integration: 
>> 
>> 
>> RT-REST: http://projects.boksa.de/RT-REST/ 
>> RT-REST is a Java class library to interact with RT: Request Tracker's REST Interface. 
>> 
>> RT-Jasper: http://projects.boksa.de/RT-Jasper/ 
>> RT-Jasper is a toolkit to integrate RT: Request Tracker as a queryable data source in JasperServer. 
>> 
>> 
>> Feel free to give the components a try and let me know what you think :-) I have chosen to drop full installation instructions in favor of a demo system (see the RT-Jasper page for more information) and I assume you already have a RT installation to play with. To learn how to install JasperReports Server please refer to 
>> 
>> http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download . 
>> 
>> To help you with your questions I'll try to be around in #rt on irc.perl.org . 
>> 
>> I am really curious to see what you will say about my work and I hope there will be enough users using it to ensure a constant flow of great ideas and improvements. 
>> 
>> Enjoy the rest of your weekends :-) 
>> 
> Big thanks for your works. 
> 
> Two questions before I spend lot of time to understand your works : 
> 
> 1/ What kind of reports can we have (I never heard of jasper, only 
> the city in Canada ...;-) ). I didn't find your demo jasperserver 
> ...:-( 
> 
> 2/ Is they are anything to modify on the RT server ? 
> 
> thanks again. 
> 
> Regards. 
> -- 
> Albert SHIH 
> DIO bâtiment 15 
> Observatoire de Paris 
> 5 Place Jules Janssen 
> 92195 Meudon Cedex 
> Téléphone : 01 45 07 76 26/06 86 69 95 71 
> xmpp: jas at obspm.fr 
> Heure local/Local time: 
> jeu 26 avr 2012 21:25:37 CEST 
> 







-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120427/6b0d4340/attachment.htm>