How to map a distinct array of results from a column (field) to a list?

[Maryna Brodina]

Hi, it's a bug unfortunately. We'll fix it.

[bahar.wadia]

I will wait for the fix. Any idea when a fix will be available?

Also, any work arounds in the meantime ?

Thank you and keep up the good work. The response time on you side is superb.

I wish more companies would be like you.

[Maryna Brodina]

Hello! Thank you for your feedback! Sorry, not sure for now when it's going to be fixed. You can use "add level" buttons in service editor to add fields to the "where" parameter when passing it into POST services (as for now, we require an object there, not a string). Another workaround would be to wrap the string value into JSON.parse before sending it to the server.

[bahar.wadia]

Thanks for you response. As a newbie, can you please help me understand your suggestions with an example or two. Very much appreciate your help.

Thanks in advance.

[bahar.wadia]

Thanks for you response. As a newbie, can you please help me understand your suggestions with an example or two. Very much appreciate your help.

Thanks in advance.

[Maryna Brodina]

Hello! The first workaround shown on screenshot

The second one:
on page click Data, for Request parameter "where" click "Add JS":
codereturn JSON.parse(value);/code

[bahar.wadia]

The first workaround works like a charm. Have not tried the second work around.

You guys are awesome.

[bahar.wadia]

Have you tried this with the List component?

I am able to .append() the distinct values to the List, but the list is not clickable.

What am I missing ? See my code snippet below...

----------------------------------------------

var Items = arguments[0];

Items.sort();

var FoundList = Appery("mobilelist_FoundItems");

FoundList.empty();
$.each(Items, function(index, option)
{
FoundList.append("" + option + "");
});

FoundList.listview("refresh");

----------------------------------------------

Thank you for your help.

[Maryna Brodina]

Hello! We'll take a look and let you know.

[bahar.wadia]

btw - I noticed that the "//" and \\ are not showing up in the message above, but I do have them there.