Page 2 of 3

"edit js' code on where for query which takes input values for 2 variables and does collection lookup, then allows anoth

Posted: Tue Feb 11, 2014 8:21 pm
by kabrams

When I remove the 'where', I get the below results, which still isn't correct..

Image


"edit js' code on where for query which takes input values for 2 variables and does collection lookup, then allows anoth

Posted: Tue Feb 11, 2014 9:17 pm
by Kateryna Grynko

I mean this parameter 'where': http://docs.appery.io/documentation/b...
Where do you paste your code?


"edit js' code on where for query which takes input values for 2 variables and does collection lookup, then allows anoth

Posted: Tue Feb 11, 2014 9:26 pm
by kabrams

Request tab, 'where' editjs


"edit js' code on where for query which takes input values for 2 variables and does collection lookup, then allows anoth

Posted: Tue Feb 11, 2014 10:05 pm
by Kateryna Grynko

Please make sure these localStorage variables aren't empty and contain correct values. You can check service work on test values in service 'Test' tab.


"edit js' code on where for query which takes input values for 2 variables and does collection lookup, then allows anoth

Posted: Wed Feb 12, 2014 6:20 pm
by kabrams

This is the response i get on that query

{
"status":"400 Bad Request",
"url":"https://api.appery.io/rest/1/db/colle...",
"response":{
"code":"DBSQ219",
"description":"Incorrect query"
}
}


"edit js' code on where for query which takes input values for 2 variables and does collection lookup, then allows anoth

Posted: Wed Feb 12, 2014 6:24 pm
by kabrams

The service works fine without the where parameter? Seems like something is wrong with the 'where' parameter.


"edit js' code on where for query which takes input values for 2 variables and does collection lookup, then allows anoth

Posted: Wed Feb 12, 2014 7:09 pm
by Kateryna Grynko

Could you please post a screenshot of request in Network tab?


"edit js' code on where for query which takes input values for 2 variables and does collection lookup, then allows anoth

Posted: Wed Feb 12, 2014 8:27 pm
by kabrams

ok i also wanted to share this test

Image


"edit js' code on where for query which takes input values for 2 variables and does collection lookup, then allows anoth

Posted: Wed Feb 12, 2014 8:28 pm
by kabrams

"edit js' code on where for query which takes input values for 2 variables and does collection lookup, then allows anoth

Posted: Wed Feb 12, 2014 8:38 pm
by kabrams