# Bug in filters (MySQL)

**URL:** <https://community.dreamfactory.com/t/bug-in-filters-mysql/2064>\
**Category:** REST API\
**Created:** [January 20, 2016, 11:08pm UTC](https://community.dreamfactory.com/t/bug-in-filters-mysql/2064 "2016-01-20T23:08:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajivperera](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/rajivperera/32/88_2.png) [@rajivperera](https://community.dreamfactory.com/u/rajivperera)\
**Post date:** [January 20, 2016, 11:08pm UTC](https://community.dreamfactory.com/t/bug-in-filters-mysql/2064/1 "2016-01-20T23:08:17Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![kimpatro](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/kimpatro/32/467_2.png) [@kimpatro](https://community.dreamfactory.com/u/kimpatro)\
**Post date:** [January 26, 2016, 11:48am UTC](https://community.dreamfactory.com/t/bug-in-filters-mysql/2064/2 "2016-01-26T11:48:35Z")

</div>

Hi,

could you give the code of the call?  
Is the filter in simple quotes or double quotes?  
Have you tried to scape the \*?  
Instead of filter, did you try use expression ?

Just guessing.