[resolved] many conditions in expression filter of TMap

[Anonymous]

How can I write many conditions in the expression filter of TMap (to have the same result than a SQL request). Is it in Talend a symbol to write an "and" function like this? :
SELECT
REF.CMAITRE,
ARTICLE.CART,
REF.LREF,
LIGNE.LLIGNE,
ARTICLE.STATCOM,
ARTICLE.STATSUP
FROM
ARTICLE,
REF,
LIGNE,
MARQUE
WHERE
( REF.CMAITRE=ARTICLE.CMAITRE )
AND ( ARTICLE.CLIGNE=LIGNE.CLIGNE )
AND ( MARQUE.CMARQUE=REF.CMARQUE )
AND (
MARQUE.LMARQUE = 'JEAN DUPOND XX'
AND ARTICLE.STATCOM = 'RECYC'
)

[Anonymous · Accepted solution]

Hello

Is it in Talend a symbol to write an "and" function like this?

Try '&&' for 'and', '||' for 'or', for example:

row1.id>2&&row1.name.equals("John")

Best regards
shong

[Anonymous]

How can I put a sql query in entry which displays fields from many tables and not just from one table?

[Anonymous]

hello,
you can create your own SQL query with the tDBInput :
in Basic settings, use the Query panel to write your custom SQL query. you need to have a Talend built-in schema like your SQL select

[Jcs19]

Hello

Is it in Talend a symbol to write an "and" function like this?

Try '&&' for 'and', '||' for 'or', for example:

row1.id>2&&row1.name.equals("John")

Best regards
shong

Thanks you saved me