Problem with Where parameter with php curl from external application

[Michele]

Hi, I've got a problem.
I'm using curl with php to connect to my app database on appery.io server.
Everything works fine, except filtering.
I get my list of objects from the users collection and I can sort it without any problem, but seems it can't be filtered.

This is the array I'm passing as get param to my query:

array('sort'='nome','where'=array('ruolo'='agente')

The result is the sorted list of objects without the filtering on the "ruolo" field.

May you help me, please?
Thanks in advance

[Serhii Kulibaba]

Hello Michele,

You need use where as JSON object, not as an array

[Michele]

Hello Sergiy,

I tried to pass my url in this way:

?sort=nome&where={"ruolo":"agente"}

but with no luck.
Am I doing something wrong?

[Michele]

Can you tell me if my query is correct, please?

[Serhii Kulibaba]

Please use CURL (http://php.net/manual/en/book.curl.php) for all appery.io services. E.g. for request with "where" parameter: https://devcenter.appery.io/documenta...