Page 3 of 4

Sorting database results from a service

Posted: Tue Mar 24, 2015 2:55 pm
by Ellen Schlechter

Do you have an example?


Sorting database results from a service

Posted: Tue Mar 24, 2015 3:20 pm
by Alena Prykhodko

Unfortunately we do not have ready example.


Sorting database results from a service

Posted: Wed Mar 25, 2015 11:09 pm
by Ellen Schlechter

Is it possible for it to ignore case when it sorts?


Sorting database results from a service

Posted: Fri Mar 27, 2015 12:12 am
by Yurii Orishchuk

Hi Ellen,

Unfortunatly it's not possible for this time.

All available functionality about "sort" you can find here: https://devcenter.appery.io/documenta...

Regards.


Sorting database results from a service

Posted: Tue Jun 30, 2015 7:38 am
by Jack Bua

I seem to be having an issue when trying to do a simple sort. I have a list that is being populated from a collection and I would like it sorted by account_name which is a string. I checked the case, for typos, and made sure it is on the right tab (query string, request).

http://i.imgur.com/vSCZ97d.png

This seems pretty simple, but I must be missing something. Can you help me please?


Sorting database results from a service

Posted: Tue Jun 30, 2015 7:56 am
by Jack Bua

I have found that replacing the desired sort value of "account_name" with "-account_name" returns the collection in opposite order they were created.

Also, sorting works on all the other fields as expected, just not account_name.
I hope that helps.

http://i.imgur.com/hVlAIOD.png


Sorting database results from a service

Posted: Tue Jun 30, 2015 8:07 am
by Jack Bua

I have seemed to fix the issue by deleting the data in the collection and re-running the test. All is fine now, and I would suppose that editing the collection structure between row entries caused the issue.


Sorting database results from a service

Posted: Tue Oct 06, 2015 9:37 am
by Jack Bua

how would I sort by one of the the included object's values?

Image


Sorting database results from a service

Posted: Sat Oct 10, 2015 4:01 pm
by Serhii Kulibaba

There no way to sort data by included objects using mongoDB, but you can use JS for that. Just use service's response from the service's sucess event


Sorting database results from a service

Posted: Sat Oct 10, 2015 8:16 pm
by Jack Bua

I'll have to look into that. Thank you.