jeremy Henry
Posts: 0
Joined: Fri Jul 19, 2013 1:48 pm

Distinct query using appery DB service

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

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

Distinct query using appery DB service

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

jeremy Henry
Posts: 0
Joined: Fri Jul 19, 2013 1:48 pm

Distinct query using appery DB service

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

jeremy Henry
Posts: 0
Joined: Fri Jul 19, 2013 1:48 pm

Distinct query using appery DB service

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?

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

Distinct query using appery DB service

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.

Alena Prykhodko
Posts: 0
Joined: Tue Apr 09, 2013 7:36 am

Distinct query using appery DB service

Hello Jeremy! Yes, it is planned.

jeremy Henry
Posts: 0
Joined: Fri Jul 19, 2013 1:48 pm

Distinct query using appery DB service

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,

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

Distinct query using appery DB service

Late September time frame.

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

jeremy Henry
Posts: 0
Joined: Fri Jul 19, 2013 1:48 pm

Distinct query using appery DB service

Hi Max,

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

thank you,

Return to “Issues”