How do i add the WHERE clause to the rest service for listing database entries?
and if i run it manually like this
curl -X POST
-H "X-Appery-Database-Id: 4ffcf6c8e4b0211629c4ad01"
-H "Content-Type: application/json"
-d "{'taskName':'Build an app', 'priority':'High'}"
https://api.appery.io/rest/1/db/colle...
where do i run it? i'm lost.
I can run everything on my server but i prefer the appery cloud, wish GUI had mysql Clauses like the "WHERE" clause.
Hello,
you can check here :: http://docs.appery.io/documentation/b...
i posted the question coming from that link you share, i'm a novice so i don't know where to put that code. I'm used to doing PHP, Mysql with json_encode and then map but i don't know where to put that code.
do i put it on the server side scripts or create a javascript file and run it from there?
i'm lost
I recommend you to explore our tutorials.
In this tutorial shows exactly how to setup a 'where' query:
http://docs.appery.io/tutorials/build...
Thank you, you have the best product and the best service ever
your answer was correct but what do i do when i have multiple WHERE clauses?
Hi - theoreticaly you can use a "$where" clause with JavaScript, but you should test it.
For example this two queries are equivalent:
code
... ({"$where" : "this.x + this.y == 10"})
/code
code
... ({"$where" : "function () { return this.x + this.y == 10; }"})
/code