Show yes/no instead of 1/0 on webinterface

[GMunjal]

Hi,

We implement OTRS and for customer/customer-company we implement external data source , in which many of the column contains value 1 or 0.

But as of now they all show 1 or 0 on web interface as well, but we require to show them as yes (if 1) and no (if 0) on web interface.

How can we implement this. If anyone has idea on this , it will be very helpful to us.

Thanks in advance.

Regards,
GMunjal

[reneeb]

Create your own .pm file in Kernel/System/CustomerUser/... (e.g. copy DB.pm) and change the source so that columns that are 0 are changed to "No" and 1 to "Yes".

[GMunjal]

Can you please provide me the example or complete description to implement this functionality.

Many thanks.


GMunjal

[reneeb]

Have a look at https://github.com/OTRS/otrs/blob/rel-3 ... User/DB.pm

In the sub "CustomerUserDataGet", you can add code in line 586 that sets the new values. Something like

Code: Select all

for my $Column ( qw(Column1 MyColumn) ) {
    if ( $Data{$Column} == 1 ) {
        $Data{$Column} = 'yes';
    }
    elsif ( $Data{$Column} == 0 ) {
        $Data{$Column} = 'no';
    }
}

[GMunjal]

Thanks for the information, this resolves my issue.

[crythias]

Another thought (I haven't tested) is to use the "Selections" Config.pm option for this.

See Defaults.pm for examples to use after CustomerUser Map, etc:

Code: Select all

        Selections => {

            UserField => {
                '1' => 'Yes',
                '0' => 'No',
            },
        },

[GMunjal]

Great !!

Many Thanks!!