[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