Stats shorten title name

[devel1988]

I would like to know if it is possible to pull statistics and shorten the title name.
some auto generated mails from vcenter and stuff have a very long subject name.

— [VMware vCenter - Alarm alarm.StorageConnectivityAlarm] Lost path redundancy to storage device naa.600a0b80002ae9ee0000816751b9561a. Path vmhba1:C0:T0:L6 is down. Affected datastores: DC1_ServerStorage.

if I'm pulling a report it screws up the entire layout, it for some reason has a column on the 2nd page with no data...

this is the export from otrs,

Code: Select all

<?xml version="1.0" encoding="utf-8"?>

<otrs_stats>
<Cache>0</Cache>
<Description>test</Description>
<Format>Print</Format>
<Object>TicketList</Object>
<ObjectModule>Kernel::System::Stats::Dynamic::TicketList</ObjectModule>
<ObjectName>Ticketlist</ObjectName>
<Permission>admin</Permission>
<Permission>stats</Permission>
<ShowAsDashboardWidget>0</ShowAsDashboardWidget>
<StatType>dynamic</StatType>
<SumCol>0</SumCol>
<SumRow>0</SumRow>
<Title>test</Title>
<UseAsRestriction Element="CloseTime" Fixed="1" TimeRelativeCount="7" TimeRelativeUnit="Day" TimeRelativeUpcomingCount="0">
</UseAsRestriction>
<UseAsValueSeries Element="OrderBy" Fixed="1">
<SelectedValues>Closed</SelectedValues>
</UseAsValueSeries>
<UseAsValueSeries Element="SortSequence" Fixed="1">
<SelectedValues>Up</SelectedValues>
</UseAsValueSeries>
<UseAsXvalue Element="TicketAttributes" Fixed="1">
<SelectedValues>Number</SelectedValues>
<SelectedValues>TicketNumber</SelectedValues>
<SelectedValues>Title</SelectedValues>
<SelectedValues>Created</SelectedValues>
<SelectedValues>Closed</SelectedValues>
<SelectedValues>CustomerID</SelectedValues>
</UseAsXvalue>
<Valid>1</Valid>
</otrs_stats>

[devel1988]

This is the issue i tried to explain.

Naamloos.png

[OTRSRDNewbie]

devel1988

I also new and the only way I can think of is maybe create a dynamic text field then if you have a GenericAgent or Custom module that run for these auto generate e-mails received to just add an extra code to cut the title.

Actually I have something almost similar that I need to create in a report. I need to extract a data in the title field and display it in the report. I'm not yet sure if you can customize the stats itself or be able to run some script or module in the stats itself to do that.