Sorting database results from a service
Do you have an example?
Catch up wih the Appery.io community on our forum. Here you'll find information on the lastest questions and issues Appery.io developers are discussing.
https://forum.appery.io/
Do you have an example?
Unfortunately we do not have ready example.
Is it possible for it to ignore case when it sorts?
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.
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?
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.
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.
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
I'll have to look into that. Thank you.