Sorting database results from a service

[Ellen Schlechter]

Do you have an example?

[Alena Prykhodko]

Unfortunately we do not have ready example.

[Ellen Schlechter]

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

[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.

[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?

[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

[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.

[Jack Bua]

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

[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

[Jack Bua]

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