ticket number in stats object TicketAccountedTime

[rvaldomir]

Hi,

Does anyone knows how to pull the Ticket#, accounted time just for the last month or defined period?

I don't want to use SQL at least I can define a SQL and execute it from the stats module.

As I could see the ticketlist object returns the Ticket# and Accounted time but I couldn't find a way to filter just worked time during a period.

any help?

[crythias]

I don't want to use SQL

That's ... unfortunate because
viewtopic.php?f=60&t=12546

[rvaldomir]

hi crythias,

Yes I already seen that post and we are using it as a WA but we want to provide a way to run the report from the stats module. Think about a role that only report time to a customer and they don't know about SQL

[rvaldomir]

crythias,

do you know how to use static stats?

I don't have the option to select an existing report in stats... probably If i can run it from the stats module in the website I can integrate the sql query there.

I have the default stat

Code: Select all

/opt/otrs/Kernel/System/Stats/Static
You have new mail in /var/spool/mail/otrs
[otrs@672940-usotrs01 Static]$ ls -lr
total 8
-rw-rw---- 1 otrs apache 5174 Jun 18  2014 StateAction.pm
[otrs@672940-usotrs01 Static]$

[rvaldomir]

any help about how to integrate a query using the static stats template?

[alexus]

You need to develop custom module - static report with getting data via SQL-requests.

[rvaldomir]

Yes. But how to do it? Any help or template to execute the sql from that kind of modules?

[alexus]

You can see it in /opt/otrs/Kernel/System/Stats/Static/StateAction.pm

Code: Select all

sub _GetHistoryTypes {
    my $Self = shift;

    my $SQL = 'SELECT id, name FROM ticket_history_type WHERE valid_id = 1';
    $Self->{DBSlaveObject}->Prepare( SQL => $SQL );

    my %Stats;
    while ( my @Row = $Self->{DBSlaveObject}->FetchrowArray() ) {
        $Stats{ $Row[0] } = $Row[1];
    }

    return %Stats;
}