query on OrientDB with "eval" doesn't work, the same in the orientdb console works correctly

Question

Query:

select if(eval("DWFLSRCN = 'QMSKY'"), "Total Flows", DWFLSRCN) from DWFlow;

The error is:

ErrorError parsing query: select if(, "Total Flows", DWFLSRCN) from DWFlow; ^ Encountered " "(" "( "" at line 1, column 10. Was expecting one of: ... ... ... ... ... ... ... ... ... ... ... ";" ... "," ... ... "," ... DB name="dw" DB name="dw"

The goal is to to remap a value in another, for user needs.

Example:

select if(eval("XXX= 'YYY'"), "pippo", XXX)  as test from ZZZ;

The function "isnull " works correctly.

Is there another solution?

Comments

Which version of OrientDB are you using?

---

The version is orientdb-2.2.22