Attempted a cql_filter with arithmetic with order of operations defined by parentheses as follows:
cql_filter=(PROP1 - 10) * 10 = 50
When converted into SQL to query the Oracle Data Store, this is converted to:
PROP1 - 10 * 10
Oracle does order of operations multiplication/division then addition/subtraction, which is in essence:
PROP1 - (10 * 10)
The parentheses/bracketing provided in the cql_filter must be maintained for the SQL filter.
Oracle 11g (184.108.40.206)