Forum | Appery.io

You need to specify a value for 'where'. If you don't specify a value, you will get the entire list back.

So it looks like this?

See an example here: http://docs.appery.io/tutorials/build...

You would need to enter something like this:
{"column_name":"some_value"}

Just as a side note, you can post screen shots right in the forum here. It will be simpler than linking to files...

So for my app the "column_name" is Name and some_value is also Name since I want to query whatever name I type. The tutorial is Maker:Samsung which tells me it is instructed to only query a specific type. I also changed the JS to read this:
return '{"Name":"'+value+'"}';....still nothing.

Before you try the service on the page, let's make sure it works when you test it. In the Test tab, you need to enter something like this for 'where' parameter:

{"column_name":"some_value"}

yeah the test failed and this is the message:

{
"status":"400 Bad Request",
"url":"https://api.appery.io/rest/1/db/colle...",
"response":{
"code":"DBSQ219",
"description":"Incorrect query"
}
}
So if the column in the database is 'Name' and I want to get the value of the name of the wine, isn't it Name also?? When I plugged database id into {database_id} I got this error:
'Test failed! Please check service properties and the error details in "Response" area.' Screen shot of response area:

It should be the wine name. Can you post what exactly you put for 'where'

Not sure how adding one wine name will query the other 900+ wines.
Heres the screenshots from allwines_allwinesnew3_query_service

Here's one with an actual wine from the db
http://worldofwinesclub.com/wp-conten...