Need help with transform map or fix script logic

JohnDF
Mega Sage

Hi everyone,

 

I have a requirement to set the specific product models as substitute in the cmdb_m2m_model_substitute  table.

 

JohnDF_0-1695113805384.png

That means I need to set the model (cmdb_hardware_product_model) as substitute when I find in the 4 classification custom fields in this example the word WD551 in other models field -> model description

JohnDF_1-1695113892407.png

 

JohnDF_2-1695114545453.png

 

Here another screen:

JohnDF_3-1695115112634.png

When Ifind one of thise words in classification 1-4 in model description than set this modelas substitute on the main model.

 

How can I start with some logic in fix script or transform map? Both is for me possible. But I can't wrap my head around for a good logic.

 

Any help would be nice.

 

Thanks for your help.

 

 

 

0 REPLIES 0