Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Request Tracker: Users

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

 

 

Request Tracker users RSS feed   Index | Next | Previous | View Threaded


mailinglists at boksa

Apr 27, 2012, 4:09 AM

Post #1 of 1 (279 views)
Permalink
Re: Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]

(Only sent out a private answer before, reposting to rt-users)

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).

I have also updated the installation instructions on http://projects.boksa.de/RT-Jasper after some feedback (Thx Marco!).

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
>
> From: "Benjamin Boksa" <mailinglists [at] boksa>
> To: "Albert Shih" <Albert.Shih [at] obspm>
> Cc: rt-users [at] lists
> 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
> > Heure local/Local time:
> > jeu 26 avr 2012 21:25:37 CEST
> >

Request Tracker users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.