topic Filter rows with a context value - value is an expression in Talend Studio

Filter rows with a context value - value is an expression

APIZZI1686753315 — Wed, 24 Apr 2024 14:06:40 GMT

Goal: build a data filter in context, and use the context value in a talend componant.

I use a context to create a filter expression. The value of context is correctly builded

When I show the value

System.out.println( " string : " + context.sSearchExpr );

Result :

string : ( !( input_row.isIntern ) ) && ( !( input_row.isExternalEmail )

Now, how do use my context value in any talend componant( tFilterRow or tJavaRow)

Help me

Thanks.

Re: Filter rows with a context value - value is an expression

Shicong_Hong — Thu, 25 Apr 2024 03:07:20 GMT

Hello

It will not work. the filter expression will be treated as a string, however, the filter expression field requires a boolean value.

Regards,
Shicong

Re: Filter rows with a context value - value is an expression

billimmer — Fri, 03 May 2024 13:35:20 GMT

Shicong_Hong is correct. It will be treated as a string. But, in java you can convert a string into a statement, execute it. From the web:

String javaCode = "if (polishScreenHeight >= 200 && polishScreenHeight <= 235 && polishScreenWidth >= 220) { }";
// Convert the Java String to a Java statement
Statement statement = new Statement(null, javaCode, null);
// Execute the statement
statement.execute();

Re: Filter rows with a context value - value is an expression

manojkvrajan — Fri, 03 May 2024 14:19:58 GMT

Can you provide me more insight on the use case?