[rt-users] statistics query

[Ruslan Zakirov]

On 1/17/06, Kelly F. Hickel <kfh at mqsoftware.com> wrote:
>
[snip]

>
> Looking at the code in CallsQueueDay/index.html, I don't see any way to
> overcome this in the RTx::Statistics package, it must be something
> happening under the covers.  The excerpted code that generates this
> query looks like this:
>
> %         my $tix = new RT::Tickets($session{'CurrentUser'});
put here
               $tix->{'allow_deleted_search'} = 1; # and put it
whenever you want deleted in stats

> %         $tix->LimitQueue (VALUE => $Queue);
> %             $tix->LimitStatus(VALUE => 'deleted');
> %             $tix->LimitLastUpdated(VALUE => $dates[$d]->ISO, OPERATOR
> => ">=");
> %             if ($dates[$d+1]) {
> %                 $tix->LimitLastUpdated(VALUE => $dates[$d+1]->ISO,
> OPERATOR => "<=");
> %             }
>
>
> --Kelly
>


--
Best regards, Ruslan.