OTRS.ru

Код: Выделить всё

    my $DBObject = $Kernel::OM->Get('Kernel::System::DB');
    $DBObject->Prepare(
    SQL   => "
        SELECT COUNT(*)
        FROM ticket_history th 
        LEFT JOIN ticket t on t.id = th.ticket_id
        WHERE th.history_type_id = 30
        AND t.id = $Param{TicketID}
        ",
    Limit => 1,
    );
    my @CRows = $DBObject->FetchrowArray();
    my $CountLink = @CRows[0];
    my $DynamicFieldValueObject = $Kernel::OM->Get('Kernel::System::DynamicFieldValue');
    $DynamicFieldValueObject->ValueSet(
            FieldID            => (Тут укажи id созданного динамического поля),
            ObjectID           => $Param{TicketID},
            Value              => [
                {
              ValueText => $CountLink,
                },
            ],
        UserID             => 1,
    );