Hi,
*DB Customer backend field:*
Similar as above - just add the field in Ticket::Frontend::AgentTicketQueue###DefaultColumns. For me, this field is CustomerLanguage.
On top of this, you need to tell OTRS how to retrieve the information - I added this in Kernel/Output/HTML/TicketOverviewSmall.pm around line 1258:
# customer info (customer language) if ( $Param{Config}->{CustomerInfo} ) { if ( $Article{CustomerUserID} ) { my %CustomerUser = $Self->{CustomerUserObject}->CustomerUserDataGet( User => $Article{CustomerUserID}); if ($CustomerUser{UserLanguage}) { $Article{CustomerLanguage} = $CustomerUser{UserLanguage}; } } }
Allowing Sorting / Filtering based on those values still challenges me... This is configured in Kernel/Output/HTML/TicketOverviewSmall.pm around lines 150, but it requires the definition of Filtering / Sorting functions, which is a bit tricky in my case because the data is stored in an external DB.
Olivier
or you might store this information (customer language) directly in a dynamic field, which you can then display in the queue view, without modifying any code. See here: http://doc.otrs.org/3.3/en/html/external-backends.html#dynamicfield-from-cus... --Mathias