[rt-users] Retrieving CustomFields with RT-Jasper

2013-04-29 Thread Michael Keetman 
Hello,

I am not entirely sure this is the right forum for this question, however the 
only other information I can find about RT-Jasper is in this and the Devel 
mailing lists.

I have managed to install the RT-Jasper and RT-REST packages, and successfully 
run a report with the ID and Subject shown (both fields exposed directly) using 
Jasper Reports server, however I have had no luck getting any Custom Fields to 
return any data.

Can anyone supply sample JRXML showing how this is done?

Regards,

Michael Keetman

Re: [rt-users] Retrieving CustomFields with RT-Jasper

2013-04-29 Thread Ruslan Zakirov 
On Mon, Apr 29, 2013 at 10:41 AM, Michael Keetman 
michael.keet...@qcn.com.au wrote:

 Hello, 

 ** **

 I am not entirely sure this is the right forum for this question, however
 the only other information I can find about RT-Jasper is in this and the
 Devel mailing lists.  

 ** **

 I have managed to install the RT-Jasper and RT-REST packages, and
 successfully run a report with the ID and Subject shown (both fields
 exposed directly) using Jasper Reports server, however I have had no luck
 getting any Custom Fields to return any data.  

 ** **

 Can anyone supply sample JRXML showing how this is done?


Isn't it easier to let jasper talk to RT's DB directly?


 **

 Regards,

 ** **

 *Michael Keetman*

 ** **




-- 
Best regards, Ruslan.

Re: [rt-users] Retrieving CustomFields with RT-Jasper

2013-04-29 Thread k...@rice.edu 
On Mon, Apr 29, 2013 at 08:23:34PM +0400, Ruslan Zakirov wrote:
 On Mon, Apr 29, 2013 at 10:41 AM, Michael Keetman 
 michael.keet...@qcn.com.au wrote:
 
  Hello, 
 
  ** **
 
  I am not entirely sure this is the right forum for this question, however
  the only other information I can find about RT-Jasper is in this and the
  Devel mailing lists.  
 
  ** **
 
  I have managed to install the RT-Jasper and RT-REST packages, and
  successfully run a report with the ID and Subject shown (both fields
  exposed directly) using Jasper Reports server, however I have had no luck
  getting any Custom Fields to return any data.  
 
  ** **
 
  Can anyone supply sample JRXML showing how this is done?
 
 
 Isn't it easier to let jasper talk to RT's DB directly?
 
 

Jasper can definitely talk to RT's DB directly very simply. The problem
is that then you have to implement RT in the report tool. Using REST
makes access trivial.

Regards,
Ken

Re: [rt-users] Retrieving CustomFields with RT-Jasper

2013-04-29 Thread Michael Keetman 
Hi,

I have made some progress with this after a good night's sleep.

First of all, I pulled in a patch which exposes all the global fields (details 
here: https://github.com/bboksa/RT-REST/pull/1) (instead of just id, subject 
and timeworked)

Secondly, I spent time with the JRXML and a java debugger, and discovered the 
main problem is that the customFields is a hashmap supplied to the Reports 
server.  This needs to be dereferenced and cast to the appropriate class 
(RTCustomField) to access the values. 

An example:
Specification of the field:
field name=customFields class=java.util.HashMap/

Then when defining the text field in the report, this then needs to be cast to 
expose the customField value (in this case a custom field indicating the 
Incident Start DateTime) like so:
textField
reportElement uuid=5e0163ad-3c25-4b20-b0d1-10bb957dd053 x=23 y=0 
width=100 height=20/
textElement/

textFieldExpression![CDATA[((de.boksa.rt.model.RTCustomField)$F{customFields}.get(Incident
 Start DateTime)).getValue()]]/textFieldExpression
/textField

Hopefully this is understandable, and is helpful.  I am not a Java programmer 
by any means, so if anyone here can suggest a better method, I am all ears.

Regards, 

Michael Keetman

-Original Message-
From: k...@rice.edu [mailto:k...@rice.edu] 
Sent: Tuesday, 30 April 2013 2:51 AM
To: Ruslan Zakirov
Cc: Michael Keetman; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Retrieving CustomFields with RT-Jasper

On Mon, Apr 29, 2013 at 08:23:34PM +0400, Ruslan Zakirov wrote:
 On Mon, Apr 29, 2013 at 10:41 AM, Michael Keetman  
 michael.keet...@qcn.com.au wrote:
 
  Hello, 
 
  ** **
 
  I am not entirely sure this is the right forum for this question, 
  however the only other information I can find about RT-Jasper is in 
  this and the Devel mailing lists.  
 
  ** **
 
  I have managed to install the RT-Jasper and RT-REST packages, and 
  successfully run a report with the ID and Subject shown (both fields 
  exposed directly) using Jasper Reports server, however I have had no 
  luck getting any Custom Fields to return any data.  
 
  ** **
 
  Can anyone supply sample JRXML showing how this is done?
 
 
 Isn't it easier to let jasper talk to RT's DB directly?
 
 

Jasper can definitely talk to RT's DB directly very simply. The problem is that 
then you have to implement RT in the report tool. Using REST makes access 
trivial.

Regards,
Ken