<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000'>wow! Awesome.<br><br>I am going to try this immediately.<br><br>Thanks so much for the quick reply too.<br><br>Alex<br><br><hr id="zwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Benjamin Boksa" <mailinglists@boksa.de><br><b>To: </b>"Alex Rhys-Hurn" <alex@itworx.co.ke><br><b>Sent: </b>Friday, 27 April, 2012 1:24:03 PM<br><b>Subject: </b>Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]<br><br><div>Hi Alex,</div><div><br></div><div>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:</div><div><br></div><div><a href="http://requesttracker.wikia.com/wiki/REST" target="_blank">http://requesttracker.wikia.com/wiki/REST</a></div><div><br></div><div>Among other data you get the "TimeWorked" field already calculated ;-)</div><div><br></div><div>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).</div><div><br></div><div>Looking forward to you feedback</div><div><br></div><div>Benjamin</div><div><br></div><div><br></div><br><div><div>Am 27.04.2012 um 12:09 schrieb Alex Rhys-Hurn:</div><br class="Apple-interchange-newline"><blockquote><div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0); ">Dear Benjamin,<br><br>Thanks for all the hard work.<br><br>I have in fact played with Jasper and RT before.<br><br>I gave up as the reports I was trying to generate were to do with time worked.<br><br>RT seems to have two different places where time is recorded and calculated, and so querying the DB gets complicated.<br><br>Does your integration of Jasper with RT make this clearer / easier?<br><br>or do you have any example SQL queries for reporting on Time worked in RT?<br><br>Thanks so much,<br><br>Alex<br><br><hr id="zwchr"><div style="color: rgb(0, 0, 0); font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica, Arial, sans-serif; font-size: 12pt; "><b>From:<span class="Apple-converted-space"> </span></b>"Benjamin Boksa" <<a href="mailto:mailinglists@boksa.de" target="_blank">mailinglists@boksa.de</a>><br><b>To:<span class="Apple-converted-space"> </span></b>"Albert Shih" <<a href="mailto:Albert.Shih@obspm.fr" target="_blank">Albert.Shih@obspm.fr</a>><br><b>Cc:<span class="Apple-converted-space"> </span></b><a href="mailto:rt-users@lists.bestpractical.com" target="_blank">rt-users@lists.bestpractical.com</a><br><b>Sent:<span class="Apple-converted-space"> </span></b>Thursday, 26 April, 2012 10:59:37 PM<br><b>Subject:<span class="Apple-converted-space"> </span></b>Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]<br><br>Hi Albert,<br><br>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).<br><br>Regarding your questions:<br><br>1) See the private mail I sent you.<br>2) No.<br><br>If you have further questions just let me know.<br><br>Greetings from Cologne<br><br>Benjamin<br><br><br><br><br>Am 26.04.2012 um 21:28 schrieb Albert Shih:<br><br>> Le 22/04/2012 ? 19:11:23+0200, Benjamin Boksa a écrit<br>> Hi.<br>><span class="Apple-converted-space"> </span><br>>><span class="Apple-converted-space"> </span><br>>> it's done :-) I have setup two GitHub repositories to host everything you need to run you own RT an JasperReports Server integration:<br>>><span class="Apple-converted-space"> </span><br>>><span class="Apple-converted-space"> </span><br>>> RT-REST:<span class="Apple-converted-space"> </span><a href="http://projects.boksa.de/RT-REST/" target="_blank">http://projects.boksa.de/RT-REST/</a><br>>> RT-REST is a Java class library to interact with RT: Request Tracker's REST Interface.<br>>><span class="Apple-converted-space"> </span><br>>> RT-Jasper:<span class="Apple-converted-space"> </span><a href="http://projects.boksa.de/RT-Jasper/" target="_blank">http://projects.boksa.de/RT-Jasper/</a><br>>> RT-Jasper is a toolkit to integrate RT: Request Tracker as a queryable data source in JasperServer.<br>>><span class="Apple-converted-space"> </span><br>>><span class="Apple-converted-space"> </span><br>>> 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<br>>><span class="Apple-converted-space"> </span><br>>><span class="Apple-converted-space"> </span><a href="http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download" target="_blank">http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download</a><span class="Apple-converted-space"> </span>.<br>>><span class="Apple-converted-space"> </span><br>>> To help you with your questions I'll try to be around in #rt on<span class="Apple-converted-space"> </span><a href="http://irc.perl.org" target="_blank">irc.perl.org</a><span class="Apple-converted-space"> </span>.<br>>><span class="Apple-converted-space"> </span><br>>> 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.<br>>><span class="Apple-converted-space"> </span><br>>> Enjoy the rest of your weekends :-)<br>>><span class="Apple-converted-space"> </span><br>> Big thanks for your works.<br>><span class="Apple-converted-space"> </span><br>> Two questions before I spend lot of time to understand your works :<span class="Apple-converted-space"> </span><br>><span class="Apple-converted-space"> </span><br>> 1/ What kind of reports can we have (I never heard of jasper, only<br>> the city in Canada ...;-) ). I didn't find your demo jasperserver<br>> ...:-(<br>><span class="Apple-converted-space"> </span><br>> 2/ Is they are anything to modify on the RT server ?<span class="Apple-converted-space"> </span><br>><span class="Apple-converted-space"> </span><br>> thanks again.<br>><span class="Apple-converted-space"> </span><br>> Regards.<br>> --<span class="Apple-converted-space"> </span><br>> Albert SHIH<br>> DIO bâtiment 15<br>> Observatoire de Paris<br>> 5 Place Jules Janssen<br>> 92195 Meudon Cedex<br>> Téléphone : 01 45 07 76 26/06 86 69 95 71<br>> xmpp:<span class="Apple-converted-space"> </span><a href="mailto:jas@obspm.fr" target="_blank">jas@obspm.fr</a><br>> Heure local/Local time:<br>> jeu 26 avr 2012 21:25:37 CEST<br>><span class="Apple-converted-space"> </span><br><br></div><br></div></div><br class="Apple-interchange-newline"></blockquote></div><br></div><br></div></body></html>