Unable to export csv contains custom column by searching CMDB

[takeno]

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.

[josemiguelgonzalezu]

I've been looking and I can't find the functionality to let this field be editable to add more data/values.

despite how many times it is modified... the result is always the same, the column is added but it has no value

Znuny could indicate that these requirements are out of reach so as not to continue trying.

[root]

I've been looking and I can't find the functionality to let this field be editable to add more data/values.

despite how many times it is modified... the result is always the same, the column is added but it has no value

Znuny could indicate that these requirements are out of reach so as not to continue trying.

Hi,

Maybe you let us know what your problem is instead of adding sth to a 5-year-old post?

- root

[josemiguelgonzalezu]

Hi,

1.- Add new fields to my class definition in:
Field1
Field2
Field3
2.- Is it possible that these fields and their values ​​appear in the excel or csv search results?

I have only been able to add them to the header of the excel or csv, but the values ​​do not appear, so I do not understand why this configuration exists ITSMConfigItem::Frontend::AgentITSMConfigItemSearch###SearchCSVData

I would believe that it is to add fields and values ​​that are not the ones provided by the class by default.