Unable to export csv contains custom column by searching CMDB

Moderator: crythias

Post Reply
takeno
OTRS newbie
Posts: 17
Joined: 06 Sep 2017, 14:33
OTRS Version?: OTRS6
Location: Kanagawa,Japan

Unable to export csv contains custom column by searching CMDB

Post by takeno » 11 Jul 2019, 11:05

Hello.

We need to provide end user with exporting csv file contains custom columns at when searching CMDB.
I had setup in ITSMConfigItem::Frontend::AgentITSMConfigItemSearch as shown below.
byclass.png
ITSMConfigItemSearch.PNG
In my expectation, cert::SerialNumber::1 should have been able to obtain the value, but the value is missing.
I tried other notations but the results are the same.

Please someone help me.

[Actual result:configitem_search_2019-07-12_00-36.csv]

Code: Select all

"Class";"Incident State";"Name";"ConfigItem#";"Change State";"Version";"Create Time";"cert::SerialNumber::1";"Last changed";"SerialNumber";"SerialNumber::1";"Serial Number"
"cert";"Operational";"u02-test01.hogefuga.ne.jp";"07149000005";"Production";"54";"2019-07-12 00:25:42"
"cert";"Operational";"u02-test02.hogefuga.ne.jp";"07149000004";"Production";"53";"2019-07-12 00:24:55"
[Expected result]

Code: Select all

"Class";"Incident State";"Name";"ConfigItem#";"Change State";"Version";"Create Time";"Serial Number";"Last changed";"SerialNumber";"SerialNumber::1";"Serial Number"
"cert";"Operational";"u02-test01.hogefuga.ne.jp";"07149000005";"Production";"54";"2019-07-12 00:25:42";"a08800a10000001";"2019-07-12 00:24:55";;;
"cert";"Operational";"u02-test02.hogefuga.ne.jp";"07149000004";"Production";"53";"2019-07-12 00:24:55";"ef8090cd0000023";"2019-07-12 00:25:55";;;
[Version]
  • CentOS: 7.6.1810
    OTRS: 5.0.23-01
    ITSM: 5.0.23
[Config Item Class: cert]

Code: Select all

[ 
    { 
        Key => 'Vendor', 
        Name => 'Vendor', 
        Searchable => 1, 
        Input => { 
            Type => 'Text', 
            Size => 50, 
            MaxLength => 50, 
        }, 
    }, 
    { 
        Key => 'Description', 
        Name => 'Description', 
        Searchable => 1, 
        Input => { 
            Type => 'TextArea', 
        }, 
    }, 
    { 
        Key => 'SerialNumber', 
        Name => 'Serial Number', 
        Searchable => 1, 
        Input => { 
            Type => 'Text', 
            Size => 50, 
            MaxLength => 50, 
        }, 
    }, 
 ## omit
 ## omit
];
Edit: Even after updating to 6.0.19, the problem is still going on.
You do not have the required permissions to view the files attached to this post.
OTRS 6.0.19, CentOS 7, postgreSQL 9.2.4

Post Reply