Filter based on global Variable

[xfrancom]

Hi,

I want to apply a custom filter from csv file if a condition is true
if this conditions = true -> ((Integer)globalMap.get("FiltraDiasSinStock") != 0)
Apply Filter -> row1.FechaUltimaEntrada.compareTo("") != 0 && row1.FechaUltimaEntrada.compareTo("25/11/2015") != 0
Else -> No filter is applied

Thank you

[Anonymous]

Hi,


Could you please elaborate your case with an example with input and expected output values?

Ie seems you are looking for tenary operation in tmap: Condition?value if true: value if false
Please take a look at component TalendHelpCenter:tMap.

Best regards
Sabrina

[xfrancom]

This is jus what i have tried in tmap/filter, but does'nt work when (Integer)globalMap.get("FiltraDiasSinStock") == 0 (else condition)

((Integer)globalMap.get("FiltraDiasSinStock") != 0) ?
(row1.FechaUltimaEntrada.compareTo("") != 0 && NormalizaFecha.ConvertSimpleDateFormat(row1.FechaUltimaEntrada).compareTo(TalendDate.addDate(TalendDate.getDate("yyyyMMdd"),"yyyyMMdd",(Integer)globalMap.get("FiltraDiasSinStock"),"dd")) > 0) :
true