topic Re: Calculate an attribute onchange of another attribute in Windchill Customization

Calculate an attribute onchange of another attribute

Sha11 — Fri, 15 Mar 2024 14:04:38 GMT

Hello,

I have a requirement where I have to populate an attribute if a specific value was selected for one of the other attributes. The user will not view the object after editing, so I cannot make of data utility and layout.

I know that we can use a data utility to record the onchange() event using comboBox and invoke a jsp file. But I am not sure what exactly to be done after invoking a method in jsp file since I want to invoke a java method which will do a set of validation and manipulation to calculate the attribute value.

Requesting all to shed some light on the possible solution.

Thanks,

Hari

Re: Calculate an attribute onchange of another attribute

joe_morton — Mon, 12 Dec 2022 15:43:44 GMT

Have you looked into using calculated attributes? Might be a simpler approach.

Reference: https://www.ptc.com/en/support/article/cs41117

Re: Calculate an attribute onchange of another attribute

Sha11 — Thu, 15 Dec 2022 08:34:59 GMT

Hello @joe_morton ,

There are many validations that I need to perform and also establish DB connection for the calculation of the attribute, hence I do not think this requirement can be achieved through Calculated attribute functionality. Is it possible to invoke a custom java method through calculated attribute formula?

Re: Calculate an attribute onchange of another attribute

BjoernRueegg — Thu, 15 Dec 2022 12:40:28 GMT

If you would like to do it with calculated attributes, you can implement your own logic. Create a class and implement it with

implements BusinessAlgorithm

see the development guide for an example https://support.ptc.com/help/wnc/r12.1.1.0/en/#page/Windchill_Help_Center/customization/WCCG_BusLogicCust_TypeManager_CalculatedAttribute.html

If you rather would like to store it as a value in the database, then you need to create a Pre Checkin trigger to set the attribute based on the other attribute values.

Re: Calculate an attribute onchange of another attribute

Sha11 — Fri, 16 Dec 2022 07:48:21 GMT

Hello @BjoernRueegg ,

Thank you for your suggestion, I have implemented the calculated attribute functionality and its almost working as expected. I am facing one issue in a use case, I want this new attribute to be calculated when its null or blank, if the calculated attribute has a value, new value is not needed to be calculated.

I wrote this value check logic using persistable adapter as shown below.

PersistableAdapter obj = new PersistableAdapter(data, null, SessionHelper.getLocale(), new UpdateOperationIdentifier());

obj.load("calculatedAttribute");

String testNumber = (String) obj.get("calculatedAttribute");

if(testNumber==null || StringUtils.isBlank(testNumber)) {

//method to calculate the attribute value

}

Somehow an exception is being thrown in the obj.load() line, do you have any suggestion as to how we can easily determine if the value is null or not before or after invoking the execute method of business algorithm.

PFA log file with exception stack trace.

Re: Calculate an attribute onchange of another attribute

rhart — Fri, 16 Dec 2022 09:42:13 GMT

You can call the obj.load inside a try{} and then handle the exceptions in a catch{}, that’s the way I’ve been doing it so I hope it’s right

Re: Calculate an attribute onchange of another attribute

Sha11 — Fri, 16 Dec 2022 09:45:00 GMT

I have done it in the same way, but where I am confused is why the obj.load() line is giving an exception. The attribute that I am trying to load is associated with the object but still some exception is getting triggered.

Re: Calculate an attribute onchange of another attribute

BjoernRueegg — Fri, 16 Dec 2022 10:41:09 GMT

Why are you loading the Persistable Adapter with the UpdateOperationIdentifier? Please change that one to:

PersistableAdapter obj = new PersistableAdapter(object, null, SessionHelper.getLocale(), new DisplayOperationIdentifier());

Could it be, that this attribute is not on the edit layout?