Forum | Appery.io

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

Hello Michele,

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

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?

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

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...