My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Agile PLM Framework - Version and later
Information in this document applies to any platform.


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.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.