Can't use "where" condition in REST request retrieving distinct values
Posted: Tue Sep 03, 2013 12:17 am
Hello - can you show a sample of your collection?
Forum | Appery.io
Catch up wih the Appery.io community on our forum. Here you'll find information on the lastest questions and issues Appery.io developers are discussing.
https://forum.appery.io/
Can't use "where" condition in REST request retrieving distinct values
Page 1 of 2
Can't use "where" condition in REST request retrieving distinct values
Posted: Tue Sep 03, 2013 10:09 am
Hi,
here's an example CSV line:
_id:string,"acl:object","UIAA:string","French:string","Fontainebleau:string","Colour:string","Name:string","Line:string","Date:string","RouteSetter:string","Sector:string","Area:string"
5224a995e4b0cfb71e4bbee6,"","VII","6b ","","yellow","Jewel in the Crown ","86","2013-08-09","Elch ","Nord-Turm","Kletterhalle Wien"
Can't use "where" condition in REST request retrieving distinct values
Posted: Tue Sep 03, 2013 2:58 pm
Hello! It's a bug unfortunately. As a workaround please use the following Request structure:
Can't use "where" condition in REST request retrieving distinct values
Posted: Wed Sep 04, 2013 9:27 pm
Hi Marina,
thanks for pointing out the workaround.
Still, this solution does not allow for a custom condition, where e.g. rows are only filtered if "name" contains certain values(or any non-null value).
For now I guess the only way to build such a "where"-condition is to implement it in javascript (calling the REST service) directly?
Can't use "where" condition in REST request retrieving distinct values
Posted: Wed Sep 04, 2013 10:05 pm
..can you tell when this bug will be fixed?
Can't use "where" condition in REST request retrieving distinct values
Posted: Wed Sep 04, 2013 10:20 pm
It's already fixed.. we just need to push the fix to production. We'll try to do it as soon as possible.
Can't use "where" condition in REST request retrieving distinct values
Posted: Wed Sep 04, 2013 10:28 pm
That's great, thanks.
It will make appery.io an even better platform to develop mobile app prototypes.
Excellent work, by the way!
Can't use "where" condition in REST request retrieving distinct values
Posted: Tue Sep 17, 2013 10:36 am
Hi Marina,
The GUI doesn't show me the "Add level" button on the "Request" form of my service(as in your screenshot).
Do I have to do anything special?
Can't use "where" condition in REST request retrieving distinct values
Posted: Tue Sep 17, 2013 11:17 am
Please ignore my previous post. It's working as you describe it.
I had my service configured with a method of "get" instead of "post"
Can't use "where" condition in REST request retrieving distinct values
Posted: Tue Sep 17, 2013 9:28 pm
Hi Marina,
how would I use this approach to retrieve a collection(rathen than a list of distinct values from a collection)?
I can't figure out how to add a level to the "where" parameter using the "get" method.
Using the "post" method results in a request to create an entry in the collection instead of tretrieving the collection..