<html><head><base href="x-msg://121/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">(Only sent out a private answer before, reposting to rt-users)<div><br></div><div><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">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>I have also updated the installation instructions on <a href="http://projects.boksa.de/RT-Jasper">http://projects.boksa.de/RT-Jasper</a> after some feedback (Thx Marco!).</div><div><br></div><div>Looking forward to you feedback</div><div><br></div><div>Benjamin</div></div><div><br></div><div><br></div><div><br><div><div>Am 27.04.2012 um 12:09 schrieb Alex Rhys-Hurn:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0); ">Dear Benjamin,<br><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; "><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0); "><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">mailinglists@boksa.de</a>><br><b>To:<span class="Apple-converted-space"> </span></b>"Albert Shih" <<a href="mailto:Albert.Shih@obspm.fr">Albert.Shih@obspm.fr</a>><br><b>Cc:<span class="Apple-converted-space"> </span></b><a href="mailto:rt-users@lists.bestpractical.com">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: http://projects.boksa.de/RT-REST/<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: http://projects.boksa.de/RT-Jasper/<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>>> http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download .<br>>><span class="Apple-converted-space"> </span><br>>> To help you with your questions I'll try to be around in #rt on irc.perl.org .<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: jas@obspm.fr<br>> Heure local/Local time:<br>> jeu 26 avr 2012 21:25:37 CEST<br>></div></div></div></div></div></span></blockquote></div><br></div></body></html>