[Rt-devel] Reports: Customfields

Alexander Finger af at syd.de
Fri Jan 28 04:38:16 EST 2005


Hi,

I am trying to generate a "simple" report using rt 3.4rc5; I want all 
tickets which

	have been created or resolved in a given period of time
	or are new/open.

The condition I put for that is

( (Queue = 'queue0')
    OR
   (Queue = 'queue1')
    OR
   (Queue = 'queue2')
   )
AND
  ((Created > '2005-01-17') AND (Created < '2005-01-24')
   OR
    (Resolved > '2005-01-17') AND (Resolved < '2005-01-24')
   OR
    ((Status = 'new') OR (Status = 'open'))
   )

The query itself seems to return what I want.

Now, I want as well to show some custom fields in the resulting report:

% while (my $ticket = $tix->Next) {
%       my $TimeToPick;				
%       my $TimeToResolve;
       <tr>
         <td align='right'><% $ticket->id          %></td>
         <td><% $ticket->Created%></td>
         <td><% $ticket->Creator%></td>
..

         <td><%  $ticket->CustomField.{'MyCustomfield'} %></td>


       </tr>
% }


For the "CustomField", I tried various things, but either I get a mason 
error straight away or the message that the Function is not implemented.

(Ah, and I'm talking of both global and local customfields).

If anyone could hint out to me if I have to add another RT:: Module or 
use another function to show the custom field that would be very much 
appreciated.

cheers
Alex
-- 

Alexander Finger
callto://ch.eurospot.af
mailto:af at syd.de



More information about the Rt-devel mailing list