Expression Builder statcatcher

[Anonymous]

Hi,

I am trying to build an expression for our Meta data table using the tStatCatcher.

I would like to populate a field with the Moment (Timestamp), only if the Message (String) = "failure"

My current expression is: "failure".equals(row5.message)?Null:row5.moment 

Getting an error. "Null cannot be resolved to a variable."

However the component is failing, is anyone able to provide some assistance with the logic?

Thank you.

[fdenis · Accepted solution]

try it
(Date)("failure".equals(row5.message)?Null:row5.moment)
or
"failure".equals(row5.message)?(Date)Null:row5.moment
to force Null to be a Date

[Anonymous]

Hi Francois,

With (Date)("failure".equals(row5.message)?Null:row5.moment) i am receiving the attached error. 

"Null Cannot be resolved to a variable".

[fdenis]

click on code tab
go to the first error (underlined in red / reg point on the right bar)
can you show me this code part?

[Anonymous]

[fdenis]

in designer tab replace Null by null