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…

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	1451	April 5, 2016
Error on filter with related DF 2.3.1 REST API	3	2815	February 21, 2017
How to filter data query REST API	5	2807	May 19, 2015
Bug in filters (MySQL) REST API	1	1670	January 26, 2016
Multiple relationship filtering on a single call REST API	1	1391	June 12, 2020

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

Related topics