Invalid or unparsable field in filter request

REST API
1

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

2

@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))

3

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);