How to retrieve distinct values from a collection?

[Igor]

Hello,

Please try to use distinct query once more. It should work now.

[bahar.wadia]

Ok, got it to work. Had to use the POST method. The GET method does not work.

[bahar.wadia]

Now how do I populate a dropdown list with the result. The above example does not seem to work for a dropdown list.

Thanks in advance.

[Maryna Brodina]

Hello! To map results to Mobile Select Menu you need to configure your service parameters. The service you use to get distinct values from DB should have the following response structure

There is a dot (.) under response parameter "$"
This service you need to add on screen and create mapping shown on screenshot:

[Marc6388140]

Hello,

I’ve tried to follow the steps above in order to have a list of distinct values of my database (field "COMARCA"), but I ‘m getting “undefined” as result instead of them . Here attached some screenshots of how I have configured the service:

What am I doing wrong?