How to pass mapper column in Rest API filter condition

[pranil2k2]

Hi,

I have a requiremnet, where i need to pass the mapper Date column (which i read from oracle table) in REST API filter condition. i tried with below syntax, but it is giving error. please someone can advice here.

Created gt datetime’" + $CREATED + "’

if i hardoce the date value it is working — Created gt datetime’2020-04-02T11:00:00’

[dmiller]

since you are using an expression, try enabling the = button for that field and quoting the strings.

[pranil2k2]

pranil2k2:

Created gt datetime’" + $CREATED + "’

Hi Miller,

I enabled ‘=’ button and used below expression, but it is throwing error.

Created gt datetime’" + $CREATED + "’

[pranil2k2]

pranil2k2:

Created gt datetime’" + $CREATED + "’

I tried with below syntax, still it is giving same error

[cjhoward18]

It looks like your quotations are off. Are you trying to concatenate the string “created gt datetime” and the date stored in $CREATED ?

If so try this: “created gt datetme” + $CREATED

Notice the variable $CREATED is not in quotes and the static string portion is.