E1: FDA: Using LIKE Operation in Table I/O Event Rule (Doc ID 638929.1)

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.

Goal

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? 

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