Znuny and ((OTRS)) Community Edition

Dear skullz, Thank you so much for your reply! I tried the following code but turns out the excel is empty any ideas on this? Thx!!! my $SQL1 ="SELECT * FROM dynamic_field_value left join dynamic_field on dynamic_field_value.field_id = dynamic_field.id, ticket where create_time >= '$StartDate' ...

Dear all, By using the Static report, i can generate a template based on SQL. However, i would like to put all values of the dynamic fields from the same ticket to be generated on the same row. For example, [Ticket id 1 ] [Dynamic_Field1_value] [Dynamic_Field2_value] [Ticket id 2 ] [Dynamic_Field1_v...

reneeb wrote: ↑13 Feb 2019, 11:37

Code: Select all

    while ($DBObject->FetchrowArray()) {
    push @Data, $Row[0];
}

should be

Code: Select all

    while (my @Row = $DBObject->FetchrowArray()) {
        push @Data, [$Row[0]];
    }

Dear reneeb and all others,
Thank you so much for your helping. It works!

Best regards,
Frances Wong

Object handling has changed in OTRS4 sub new { my ( $Type, %Param ) = @_; # allocate new hash for object my $Self = {%Param}; bless( $Self, $Type ); return $Self; } sub Run { my ($Self, %Param) = @_; my $DBObject = $Kernel::OM->Get('Kernel::System::DB'); ... } Dear reneeb, Thank you so much for you...

Thats exactly how it supposed to be.. however under sub Run(), put you SQL instead of calling the Ticket API. check the DB API for prepare statement and fetch https://doc.otrs.com/doc/api/otrs/6.0/Perl/Kernel/System/DB.pm.html#Prepare https://doc.otrs.com/doc/api/otrs/6.0/Perl/Kernel/System/DB.pm.h...

Nope..as the dynamic list data is from TicketGet api which dont include linked ticket value.. unless u know the sql to get the linked item, you can build it by using Static stats instead Dear skullz, Thank you so much for your reply! Is there any example on the implementation of sql in Static stats...

Dear all,

Or is that possible to make the linked-object shown as an attributes in the Stats DynamicList ?

Thank you once again!

Best regards,
Frances Wong

Dear all,

After splitting the ticket into different child tickets, is that possible to shown the relation of child ticket and parent ticket in the report that provided by otrs ? Thank you so much !

Best regards,
Frances Wong

Thank you so much for all your help !!!

I tried the following code. DynamicField => { ProcessEntityID => 'Process-xxxxxxxx', ActivityEntityID => 'Activity-xxxxxxxx', (Name =>'EventName', Value => '123'), (Name => 'Organiser', Value=> '123'), (Name =>'EventStartDate', Value=> '2019-01-10'), (Name =>'EventEndDate', Value=> '2019-01-10'), (N...

Dear reneeb, I have tried to add the following code but it just create a normal ticket, is that wrong ? DynamicField => { ProcessEntityID => 'Process-xxxxxx', ActivityEntityID => 'Activity-xxxxxxx,Activity-xxxxxxx', TransitionEntityID => 'Transition-xxxxxxx,', TransitionActionEntityID => 'Transition...

With my own perl script I know how to create a normal ticket with the help of Webservice. However we have added a process with multiple activities and transitions when we create a new ticket. Is that possible to create such a process ticket through REST ?The following is my code to create a normal ...