# Querying records with multiple filters

**URL:** <https://community.dreamfactory.com/t/querying-records-with-multiple-filters/3030>\
**Category:** Client SDKs\
**Created:** [July 30, 2016, 6:13am UTC](https://community.dreamfactory.com/t/querying-records-with-multiple-filters/3030 "2016-07-30T06:13:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![digirambler](https://avatars.discourse-cdn.com/v4/letter/d/ea666f/32.png) [@digirambler](https://community.dreamfactory.com/u/digirambler)\
**Post date:** [July 30, 2016, 6:13am UTC](https://community.dreamfactory.com/t/querying-records-with-multiple-filters/3030/1 "2016-07-30T06:13:33Z")

</div>

I want to query records using multiple filters like

sub\_category\_id=1 AND unit\_offerprice \> 1350

I am using dreamfactory version 2.1.0 as client for android  
as advised in forum, I have used the following string as the filter

(sub\_category\_id%3D1) AND (unit\_offerprice%3E1350)

and getting the following exception.

java.lang.IllegalArgumentException: Illegal character in query at index 94:  
[http://dreamfactory-xxx.xxx.com/api/v2/db/\_table/product?filter=(sub\_category\_id%3D1)](http://dreamfactory-xxx.xxx.com/api/v2/db/_table/product?filter=(sub_category_id%3D1)) AND (unit\_offerprice%3E1350)

Please suggest a right way to use multiple filters as the documentation is not helping me.

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [August 8, 2016, 7:38pm UTC](https://community.dreamfactory.com/t/querying-records-with-multiple-filters/3030/2 "2016-08-08T19:38:13Z")

</div>

Preface: I don’t know anything about Java.

This is not a DreamFactory error, so a best guess is that the spaces in your URL need to be encoded:

`http://dreamfactory-xxx.xxx.com/api/v2/db/_table/product?filter=(sub_category_id%3D1)%20AND%20(unit_offerprice%3E1350)`