Forum | Appery.io

Hi,
I am calling the appery db query service at several locations. for 1 call, I want to retrieve all distinct value of a column to insert it in a list. I managed to do it. however, now this also applies to all other queries that I am performing, and I would like to avoid that.
I was thinking to duplicate the database service, but it is not allowed.
here is the URL i used to retrieve distinct values.
{database_url}/collections/activity/distinct/Activity

thank you for your help

Hello! There is no way to duplicate service, you need to create it manually.

is it the only to solve my problem? to create manually a dupe of the service and add the "DISTINCT"?

yes

ok... is it planned for a next release? this seems quite ennoying to have to that manually. It means that then i can't do anything without having to update the code manually?

Sorry, I'm not aware if this is a planned feature, but I can check and someone will get back to this post with update.

Hello Jeremy! Yes, it is planned.

ok, thanks. do you know when this is planned?
2nd question: if you know any other way to solve my problem, other than duplicating the service, that would be perfect for me.
thank you,

Late September time frame.

An alternative is to use a plug-in and import it when needed.

Hi Max,

What do you mean by importing a plug-in? using different Database such as MongoLab?

thank you,