E1: FDA: Using LIKE Operation in Table I/O Event Rule
Last updated on JULY 28, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
I am attempting to use the LIKE operation in a Table I/O statement. However the LIKE operator is not functioning correctly. The SQL statement that is being generated is performing an equal rather than a "LIKE".
For example, the SQL generated is
SELECT * FROM PRODDTA.F4220 WHERE SWSRL1 = '01541097'
when I want it to be
SELECT * FROM PRODDTA.F4220 WHERE SWSRL1 LIKE '541097%'
I am using an assignment in the event rules to set the value to a particular value, 01541097 and then use that value in table I/O. I have set Table I/O operation to the LIKE operation. How can I get this to function?
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