Forum | Appery.io

Here is another way to do this:

Manually update the response to look like this:

Thanks. A follow up question.

I initially wanted to return a distinct list for a column in the collection. I would now like to return a distinct list for the column but only where values in another column equal X.

How do I do this? I ask the question as the distinct URL seems to just focus on one column and hence even if I include a where clause (for values in another column in the collection equal to X) it makes no difference.

Regards, Shaun.

http://docs.appery.io/documentation/b...

You can add a 'where' to the query.

Thanks. I did look before hand but skipped over it somehow. Thanks.

I tried this. It does not appear to work with a dropdown list. Is this a bug or just the way REST works ?

I'll try the long way next.

Thanks

This works like a charm.

Thank you!

I am trying to do the same. I have created the REST service, with a 'where' argument. I can test it and it works fine. However, when I use it in my application it returns an error. I have checked my string construction for the where argument and it is the same as the one I use for the Test.

What am I doing wrong ?

Please can you provide some screen shots how you call it from your app?

Here are my results from the Test, so I know the query is working.

Below is the string that the app passes to the where parameter.

Below is the jqXHR error.

Hope this helps.

Thanks

Hi,

You need to debug your code, I think this page can help. You need to check Network tab for request which your app sends. Or you can show us screenshot of that request -- Headers part with request body and response.