I am using version 2.0.4
The following gives me parsing error:
filter : (agency_id = 95) and ((lat * 2) > 35)
If I don’t multiply the field LAT by 2, the filter works.
filter : (agency_id = 95) and (lat > 35)
In version 1, the filter worked and I did not get an error.
This is the MySQL query (which works):
select * from agency_employees where (agency_id = 95) and ((lat * 2) > 35);
Is this a bug or am I doing something wrong?