Scriptrunner - Update Insight Object attribute value if it was empty before

Six

Hi Community!

I want to update Insight object attribute in workflow post function. I have many object type e.g.: Monitor, Laptop, Phone. Every object type has the attribute: Status (The type of the Status attribute is Status). In the ticket there is an asset list, e.g.: monitor1, laptop1, laptop2.

I want update the attribute Status of all objects in the ticket regardless of their type. I have a working solution if the object Status value is not null (earlier somehow was set), but it's not working, if the attribute is empty:

assetList.each{asset ->
    def insightObject = iqlFacade.findObjectsByIQLAndSchema(schemaId, "key = " + asset.getObjectKey()).first();
    def attributeId = insightObject.objectAttributeBeans.find {
        objectTypeAttributeFacade.loadObjectTypeAttributeBean(it.objectTypeAttributeId).name == "Status"
    }?.objectTypeAttributeId;

    def objectTypeAttributeBean = objectTypeAttributeFacade.loadObjectTypeAttributeBean(attributeId);
    def newStatusAttributeBean = asset.createObjectAttributeBean(objectTypeAttributeBean);
    def newObjectAttributeBean = objectAttributeBeanFactory.createObjectAttributeBeanForObject(insightObject, objectTypeAttributeBean, "NewStatusName");

    def objectAttributeBean = objectFacade.loadObjectAttributeBean(insightObject.getId(), objectTypeAttributeBean.getId());
    if (objectAttributeBean != null) {
        newObjectAttributeBean.setId(objectAttributeBean.getId());
    }
    objectAttributeBean = objectFacade.storeObjectAttributeBean(newObjectAttributeBean);
}

I can get the ObjectTypeId from the asset and create a new ObjectTypeBean:

def objectTypeId = asset.getObjectTypeId();
def objectTypeBean = objectTypeFacade.loadObjectTypeBean(objectTypeId);

??????
def attributeId = objectTypeBean.getAttributeId.where(name == "Status"); //here I want to get the the current asset attribute id, where the attribute name is Status 
?????? 

But I don't know, how to get the attributeId of the current object type Status attribute by the name of the attribute!

Alex van Vucht (GLiNTECH)

Okay, here is my 'lazyUpdate' function. 'simpleAttributes' is a simple "Key: attribute name, value: list of values for that attribute" map. Just call this function with the object and map, and as long as the attribute names match, it should update in most cases. In my case, I didn't have to update object references, so you may need to extend this function a little for that.

You should have instantiated the relevant facades: 

• attrMgr: ObjectTypeAttributeFacade
• attrFty: ObjectAttributeBeanFactory
• objMgr: ObjectFacade

 

Map lazyUpdate(ObjectBean object, Map<String,List> simpleAttributes) {

/* Get metadata on attributes from object metadata (ie. the object type) */
List<ObjectTypeAttributeBean> objectTypeAttributeBeans = attrMgr.findObjectTypeAttributeBeans(object.getObjectTypeId())

List objectTypeAttributeNames = objectTypeAttributeBeans.collect{it.getName().toLowerCase()}

/* Proceed only with attributes that match keys in the map */
simpleAttributes.findAll {
it.key.toLowerCase() in objectTypeAttributeNames

}.collectEntries { attr, values ->

/* This is the object type attribute and the one we want to modify */
ObjectTypeAttributeBean objectTypeAttributeBean = objectTypeAttributeBeans.find {
it.getName().toLowerCase() == attr.toLowerCase()
}

/* Create the new attribute bean based on the value */
def newObjectAttributeBean = attrFty.createObjectAttributeBeanForObject(object, objectTypeAttributeBean, values.getAt(0) as String)

/* Load the attribute bean */
def objectAttributeBean = objMgr.loadObjectAttributeBean(object.getId(), objectTypeAttributeBean.getId());
if (objectAttributeBean != null) {
/* If attribute exist reuse the old id for the new attribute */
newObjectAttributeBean.setId(objectAttributeBean.getId());
}

/* Store the object attribute into Insight. */
try {
objectAttributeBean = objMgr.storeObjectAttributeBean(newObjectAttributeBean);
} catch (Exception vie) {
log.warn("Could not update object attribute due to validation exception:" + vie.getMessage());
}
[objectTypeAttributeBean.getName(),objectAttributeBean.getObjectAttributeValueBeans()*.getValue()]
}
}