maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

search results not displaying

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

Scott Schechtel6280324
Posts: 0
Joined: Sun Sep 29, 2013 12:03 am

search results not displaying

So it looks like this?

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

search results not displaying

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

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

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

search results not displaying

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

Scott Schechtel6280324
Posts: 0
Joined: Sun Sep 29, 2013 12:03 am

search results not displaying

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.

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

search results not displaying

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"}

Scott Schechtel6280324
Posts: 0
Joined: Sun Sep 29, 2013 12:03 am

search results not displaying

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:
Image

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

search results not displaying

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

Scott Schechtel6280324
Posts: 0
Joined: Sun Sep 29, 2013 12:03 am

search results not displaying

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

Image

Scott Schechtel6280324
Posts: 0
Joined: Sun Sep 29, 2013 12:03 am

search results not displaying

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

Return to “Issues”