How to mapping in a CHG the field KPE to Label Affected CIs

scl_amorale
Tera Expert

Hello my friends, need some help please. I need to mapping the field KPE to the label Affected CIs from the bottom "add": Add Affected CIs

 

scl_amorale_1-1743570398044.png

scl_amorale_2-1743570525585.png

 

11 REPLIES 11

Hi @scl_amorale

 

If you put your mouse cursor on TASK=INC*** then right click it and open in new window. Then you will see the table name is task_ci and your field KPE is created in CMDB_CI that's why you are not able to that field in the list view. 

 

RohitSingh_0-1743603532432.png

RohitSingh_1-1743603652717.png

I hope by this it answers the question that why that field is not visible in the List view slush bucket. 

 

As an alternative you can create a custom database view and join CI and TASK in that custom view you can add KPE attribute of Configuration Item table. Then use that custom table in the related list of Inident.

 

RohitSingh_2-1743603991598.png

 

If my response helped, please hit the Thumb Icon and accept the solution so that it benefits future readers.

 

Regards,
Rohit

 

scl_amorale
Tera Expert

Please. How to edite the  "Configuration Item table" to add the KPE attribute, in the list view

 

scl_amorale_0-1743620796420.png

 

Please check my previous response. You won’t be able to add KPE field in list view since Affected CI table doesn’t have this field.

OK. But as you can see. who can  explain this?

 

when I click  add

 

1--

scl_amorale_1-1743622576356.png

2-- I see de field KPE, The others fields is already in the Affected CIs. less field KPE

scl_amorale_0-1743622494214.png

 

Hi @scl_amorale ,

 

When you are hitting add it’s taking you to cmbd_ci table that’s why you see KPE field (refer in top left table name as Configuration) . Once you add the ci a new record is created is task_ci table which doesn’t have KPE field. Hence you can’t add KPI field in the list view. 

If my response helped, please accept solution and hit thumbs up for my efforts to answer your query.

 

Regards,

Rohit