tFilterrow Advanced condition

[ishchopra]

Hello there,

I am trying to put two conditions between or but it is not giving expected results. please help

Query:

!(input_row.Status.equals(null)) && !(input_row.Status.equals("")) ||    ----- This condition works but if i put && instead of or then it throw nullpointer error

(input_row.Status.equals("Opt-out") && input_row.SF_ID.equals(""))

I am enclosing a screenshot, the highlighted row should not appear in the results 

thanks in advance

[Anonymous · Accepted solution]

(

(input_row.Status != null )

&&

(! input_row.Status.isEmpty())

&&

! ( (input_row.Status.equals("Opt-out")) && (input_row.SF_ID == null) )

&&

! ( (input_row.Status.equals("Opt-out")) && (input_row.SF_ID.isEmpty()) )

)

[ishchopra]

sgv,

this worked like a charm.

thanks 

[Anonymous]

Yessssss !!!!! 

Good luck for the continuation,

SGV