Integration Technologies - JDE1 (MOSC)

MOSC Banner

E9.2 How to select from Table IO in a LEX using array values as an input ( is in list )

edited Nov 26, 2025 4:34PM in Integration Technologies - JDE1 (MOSC) 1 commentQuestion

Hi folks

I wish to use a LEX to select data to process, but one of the columns is a list. (from an input array of values)

How do I get a Logic Extension to select data from TBLE using an input array in a select statement using Is In List. We can't right?? (I am on 9.2.9.1)

I have an input array called products and an element called product. So I want to select on products.product (productValue)

In a data request it is very simple, see below. And this works brillaintly due to the Is In List feature

but a LEX? I am not sure how to do thatas in a LEX there is no in list option to do this.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center