Description:
When an attribute is associated with this lookup and attribute is audit enabled, a function is created with the following syntax: "ODF_AUD_<LookupId>_FCT". The SQL function wraps the NSQL query of lookup and returns a value.
When the NSQL query of a Multivalued lookup is modified the Audit Function is not updated.
Steps to Reproduce:
Expected Results: The Audit Results should be inline with the return value of the NSQL query; The Audit Function in the database should be properly modified.
Actual Results: The Audit Results returns corrupt data; The Audit Function in the database in not properly modified.
Solution:
WORKAROUND:
Double saving the NSQL Query should actually solve the issue.
First Save of NSQL Query does not modify the function as the Cache is not refreshed.
Add a line break or an extra space to the query and Save it again. This should refresh the cache with the query in First Step (Essentially the same query, without a line break)
STATUS/RESOLUTION:
This has been documented as CLRT-75782 and is in review with development.
Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component:
Please Update This Required Field