# Invalid or unparsable field in filter request

**URL:** <https://community.dreamfactory.com/t/invalid-or-unparsable-field-in-filter-request/1988>\
**Category:** REST API\
**Created:** [January 6, 2016, 1:49pm UTC](https://community.dreamfactory.com/t/invalid-or-unparsable-field-in-filter-request/1988 "2016-01-06T13:49:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cybermantec](https://avatars.discourse-cdn.com/v4/letter/c/51bf81/32.png) [@Cybermantec](https://community.dreamfactory.com/u/Cybermantec)\
**Post date:** [January 6, 2016, 1:49pm UTC](https://community.dreamfactory.com/t/invalid-or-unparsable-field-in-filter-request/1988/1 "2016-01-06T13:49:25Z")

</div>

Hi,

i am using dreamfactory 2.0.3.

filtering by an integer field throws exception of “Invalid or unparsable field in filter request.”

I have a table with a couple of fields. One date field ( del\_date ) and one integer field ( status )

setting the filter to del\_date is null works fine, setting the filter to status = 1 works fine, setting the filter to

del\_date is null and status = 1 throws the exception in the subject above.

Cheers

Ulrich

---

<div class="post-metadata">

**Author:** ![mattschaer](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/mattschaer/32/914_2.png) [@mattschaer](https://community.dreamfactory.com/u/mattschaer)\
**Post date:** [January 8, 2016, 6:10pm UTC](https://community.dreamfactory.com/t/invalid-or-unparsable-field-in-filter-request/1988/2 "2016-01-08T18:10:05Z")

</div>

@Cybermantec

A filter of a=1 AND b=2 (will not parse)

Instead do:

(a=1) AND (b=2)

Parentheses can also be nested:

ex: (a=1) AND ((b=2) OR (b=3))

---

<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 19, 2016, 6:54pm UTC](https://community.dreamfactory.com/t/invalid-or-unparsable-field-in-filter-request/1988/3 "2016-01-19T18:54:44Z")

</div>

I am using version 2.0.4  
(these were filters that worked in version 1)

This gives me the same error you mentioned.  
filter : (agency\_id = 95) and ((lat \* 2) \> 35)

If we don’t multiply LAT by 2, the filter works.  
filter : (agency\_id = 95) and (lat \> 35)

This is the MySQL query, which works fine:  
select \* from agency\_employees where (agency\_id = 95) and ((lat \* 2) \> 35);