Get changed attribute old value

Developers

I have a workflow that starts when an attribute of an asset is changed. But I also need the old value of the attribute.

Is there any way to get that?

Thanks

narehtarasyan

Posted 3 years ago · Edited 1 year ago·Last reply 3 years ago

3 comments

narehtarasyan

OP3 years ago · Edited

Hi @harryhazelwood.kubrickgroup.com

Thanks a lot, Your replies really help

harryhazelwood

·3 years ago · Edited

@nareh.tarasyan Wrote up some quick code that may help - you would have this workflow start with a trigger of “An attribute of a asset was changed.”.

I’ve written it very explicitly to follow the steps above. You can condense it as needed.

import com.collibra.dgc.core.api.dto.activitystream.FindActivitiesRequest
import com.collibra.dgc.core.api.dto.instance.comment.AddCommentRequest
import com.collibra.dgc.core.api.dto.activitystream.ActivityFilterCategory
import groovy.json.JsonSlurper; 

def slurper = new JsonSlurper();

category =new HashSet<String>()

category.add(ActivityFilterCategory.valueOf("ATTRIBUTE"))

last = activityStreamApi.getActivities(FindActivitiesRequest.builder()
						.contextId(item.id)
						.categories(category)
						.limit(1)
						.build()).getResults()[0].getDescription()

resp_parse = slurper.parseText(last)

newValue = resp_parse.get("new")
oldValue = resp_parse.get("old")


commentApi.addComment(AddCommentRequest.builder()
		  .baseResourceId(item.id)
		  .baseResourceType(item.type)
		  .content("Attribute Changed: </br>New Value: ${newValue}</br>Old Value: ${oldValue}")
		  .build())

harryhazelwood

·3 years ago · Edited

Hi @nareh.tarasyan ,

Using the Activities APIs you can check what the previous value was:

Package com.collibra.dgc.core.api.dto.activitystream

Class FindActivitiesRequest.Builder

Upon your workflow triggering I would suggest the following steps:

Use the Activities request to look for the most recent change.
Feed the builder the Asset Id (contextId) and the Category of “Attribute”. I would place a limit on the response as otherwise you will receive every possible attribute change for that asset which could be a lot over time. You are only interested in the most recent.
Your most recent change will appear at the top. The record should be of type ‘UPDATE’. - if this is triggered automatically by your change workflow you won’t have to worry about it not being at the top as it should be near instant.
The response will have the new and the old value which you can pull out.

Cheers,
Harry