Hi! I have one service that connects to a MySQL database, and I want to fetch records using a filter with two fields. Basically, I’m doing the request like this: http://dsp_url/api/v2/service/_table/tablename?filter=[field1='value1' AND field2='value2'] (I’m using test_rest.html utility, that’s w…

Problem fixed. The problem were the missing parenthesis. Here is the correct query: http://dsp_url/api/v2/service/_table/tablename?filter=(field1%3D'value1')%20AND%20(field2%3D'value2') The clue came from here: Service Type list missing after update to 2.04/ admin 2.06 Considering the need for pa…

Shooting in the dark here, but best guess is that your upgraded instance isn’t really fully upgraded. Check your vendor/dreamfactory/df-sqldb and vendor/dreamfactory/df-core directories. The changelog files should match for both your 2.0.4 image, and the instance upgraded from 2.0.3 to 2.0.4. If the…

I use you fixing method. Thanks a lot.

Hi, like filter not working in my dreamfactory. I was give my filtering section like, http://52.23.226.68/api/v2/hotfuse_webservice/_table/users?filter=username%20like%20h% Response Body: { “resource”: [] } But if I Give like http://52.36.182.60/api/v2/hotfuse_webservice/_table/users?filter=…

I tested this on a DreamFactory 2.2.0 instance with SQLite and MySQL and it seems to be working properly. What version of DreamFactory are you running and what type of database are you connecting to?

Hi todd, I am using [ api version: 2.0 ], and I was connect Mongo DB

GET test/_table/{table_name} /////////////// getHotfuseWebRecords() - Retrieve one or more records. Order of parameter getting different in same version(dreamfactory) but different hosting(is there any issue). Here I attach screenshot. HOST 1: [image] HOST2: [image] HOST2 working perfec…

These look like they belong to two separate API calls, not the same call.

Like filter not working in v2.1.6 and above in Dreamfactory. Is there any solution for it??

Filter in a GET request not working for more than one parameter

REST API

formerstaff August 3, 2016, 3:29pm 11

Closing this thread. The discussion has moved to Is there support for filtering WHERE x LIKE y?

Topic		Replies	Views
Unable to filter SQL using AND REST API	1	1468	April 5, 2016
Invalid or unparsable field in filter request REST API	2	3225	January 19, 2016
Querying records with multiple filters Client SDKs	1	3809	August 8, 2016
Error on filter with related DF 2.3.1 REST API	3	2841	February 21, 2017
Service Type list missing after update to 2.04/ admin 2.06 REST API	5	2847	January 28, 2016

Filter in a GET request not working for more than one parameter

Related topics