How to show a customer field in queue overview

Moderator: crythias

Locked
ndhvu275
Znuny advanced
Posts: 139
Joined: 06 Nov 2012, 09:02
Znuny Version: 3.x, 4.x and 5.x
Real Name: Vu Nguyen
Company: INFOdation
Location: Netherlands
Contact:

How to show a customer field in queue overview

Post by ndhvu275 »

Hi,

I'm working with OTRS 3.3, I'm trying to config a customer field in queue overview, but not found yet. My question is:
- Is it possible to do by config? If yes, please show me where in sysconfg
- I know it is possible to show dynamic field in queue overview, so I config the mapping customer field and dynamic field in DynamicFieldFromCustomerUser::Mapping. But it does not work

Please help me

Thanks a lot

Vu Nguyen
OTRS 3.x, 4.x on CentOS/Windows
MySQL database
External customer backend with MySQL, MSSQL
Customization
ndhvu275
Znuny advanced
Posts: 139
Joined: 06 Nov 2012, 09:02
Znuny Version: 3.x, 4.x and 5.x
Real Name: Vu Nguyen
Company: INFOdation
Location: Netherlands
Contact:

Re: How to show a customer field in queue overview

Post by ndhvu275 »

Hi,

Finally. I sovled this issue by a customization. For example I want to display column Customer City on AgentTicketQueue overview
In original file Custom/Kernel/Output/HTML/TicketOverviewSmall.pm. Find the words "# customer info (customer name)" and customize as below

Code: Select all

        # customer info (customer name)
        if ( $Param{Config}->{CustomerInfo} ) {
            if ( $Article{CustomerUserID} ) {
# -------------------------------------------------------------------------
# Begin customization
# Add column city on tickets overview page

                #$Article{CustomerName} = $Self->{CustomerUserObject}->CustomerName(
                #    UserLogin => $Article{CustomerUserID},
                #);
                
                my %TempUser = $Self->{CustomerUserObject}->CustomerUserDataGet(
                    User => $Article{CustomerUserID},
                );
                if (%TempUser) {
                    $Article{CustomerName} = "$TempUser{UserFirstname} $TempUser{UserLastname}";
                    $Article{CustomerCity} = $TempUser{UserCity};
                }
# End customization
# -------------------------------------------------------------------------
            }
        }
Then, go to sysconfig and add one more field CustomerCity = 2 in Ticket::Frontend::AgentTicketQueue###DefaultColumns

Hope it is useful for you

Vu Nguyen
OTRS 3.x, 4.x on CentOS/Windows
MySQL database
External customer backend with MySQL, MSSQL
Customization
Locked