alfredorz
Reputable Poster
Hi JDEFriends, how are you?
I want to apply filter in a Data Request for a field with starts with different values, I tested with assign starts with a single value and it works fine, but I want with different values.
I present my particular case, I want to get all locations what starts by A, B, C values. It in Oracle SQL is like: ELECT * FROM F4100 WHERE LMLOCN LIKE 'A%' OR LMLOCN LIKE 'B%' OR LMLOCN LIKE 'C%' or resume with a regular expresion SELECT * FROM F4100 LIKE LMLOCN LIKE '[ABC]%', in db2 is more complex SELECT * FROM CRPDTA920P.F4100 WHERE TRIM(LMMCU) = '4800' AND REGEXP_LIKE(LMLOCN, '^[ABC]');
How can to do it in a Data Request??? It's possible in any way? I'll have concate differents DR in a orchestrator?
As workaround I'm thinking create a database view to return result (in this case the value are fixed), and create the same table in JDE and create a data request for this.
Kind regards,
Alfred.
I want to apply filter in a Data Request for a field with starts with different values, I tested with assign starts with a single value and it works fine, but I want with different values.
I present my particular case, I want to get all locations what starts by A, B, C values. It in Oracle SQL is like: ELECT * FROM F4100 WHERE LMLOCN LIKE 'A%' OR LMLOCN LIKE 'B%' OR LMLOCN LIKE 'C%' or resume with a regular expresion SELECT * FROM F4100 LIKE LMLOCN LIKE '[ABC]%', in db2 is more complex SELECT * FROM CRPDTA920P.F4100 WHERE TRIM(LMMCU) = '4800' AND REGEXP_LIKE(LMLOCN, '^[ABC]');
How can to do it in a Data Request??? It's possible in any way? I'll have concate differents DR in a orchestrator?
As workaround I'm thinking create a database view to return result (in this case the value are fixed), and create the same table in JDE and create a data request for this.
Kind regards,
Alfred.