How To Setup Java PX To Validate User Inputted Data Into Certain Attribute In The Table (Doc ID 1495099.1)

Last updated on MARCH 27, 2016

Applies to:

Oracle Agile PLM Framework - Version 9.3.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 28-JUL-2014***

Goal

How to setup Java PX Event to validate user inputted data into certain attribute in the table?
For example, would like to restrict users so that input value will between 100-150 or 300-450 for the number field in the table.
So in case users enter 200 to this attribute, Java PX will cancel the change and show warning message in Web Client.
In case users enter 320 to this attribute, Java PX will allow save the change and show successfully in Web Client.

- What was done:
Created a Java PX event for Update Table using IUpdateTableEventInfo with below setting.

The Java PX event Subscriber:
Trigger Type: Pre
Execution Mode: Synchronous
Order: 0
Error Handling Rule: Stop

- Problem:
When user updated the number attribute values form "100" to "200" in the table.
Since the Java PX trigger type is pre, it can get the old values "100" by SDK code (item.getValues(new Integer(123)); ), but unable to get the updated value "200" to validate.
If you change Java PX trigger type is post, can get the new value "200" but the data is already saved.
IUpdateTableEventInfo does not have getValue(attributeID) method, and cannot get new value.


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms