Hi Eric,
OQL do not offer a NVL function. The only way that I can see is using the SQL passthrough feature with the:
CALL <sql-select-statment> AS <classname>
syntax.
Ralf
Eric Anderson schrieb:
I looked through the documentation... but couldn't see anywere where it mentions this.
How do I do a query like this
WHERE (nvl(no_of_doses, 0)+nvl(extra_doses, 0)+nvl(adjusted_doses, 0)
-nvl(under_doses, 0)-nvl(shared_doses, 0)-nvl(wasted_doses, 0)
-nvl(given_doses, 0))>0
