Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

Can't use "where" condition in REST request retrieving distinct values

Hello - can you show a sample of your collection?

Wolfgang Dietersdorfer
Posts: 0
Joined: Wed Aug 14, 2013 11:35 pm

Can't use "where" condition in REST request retrieving distinct values

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"

Maryna Brodina
Posts: 0
Joined: Thu Apr 05, 2012 7:27 am

Can't use "where" condition in REST request retrieving distinct values

Hello! It's a bug unfortunately. As a workaround please use the following Request structure:
Image

Wolfgang Dietersdorfer
Posts: 0
Joined: Wed Aug 14, 2013 11:35 pm

Can't use "where" condition in REST request retrieving distinct values

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?

Wolfgang Dietersdorfer
Posts: 0
Joined: Wed Aug 14, 2013 11:35 pm

Can't use "where" condition in REST request retrieving distinct values

..can you tell when this bug will be fixed?

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

Can't use "where" condition in REST request retrieving distinct values

It's already fixed.. we just need to push the fix to production. We'll try to do it as soon as possible.

Wolfgang Dietersdorfer
Posts: 0
Joined: Wed Aug 14, 2013 11:35 pm

Can't use "where" condition in REST request retrieving distinct values

That's great, thanks.
It will make appery.io an even better platform to develop mobile app prototypes.
Excellent work, by the way!

Wolfgang Dietersdorfer
Posts: 0
Joined: Wed Aug 14, 2013 11:35 pm

Can't use "where" condition in REST request retrieving distinct values

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?

Wolfgang Dietersdorfer
Posts: 0
Joined: Wed Aug 14, 2013 11:35 pm

Can't use "where" condition in REST request retrieving distinct values

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"

Wolfgang Dietersdorfer
Posts: 0
Joined: Wed Aug 14, 2013 11:35 pm

Can't use "where" condition in REST request retrieving distinct values

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..

Return to “Issues”