Page 1 of 2

Sorting issue with database

Posted: Wed May 28, 2014 9:19 am
by Andrea Spila

Hi there,
I have tried to add a sort parameter in Request as indicated here:
http://devcenter.appery.io/documentat...
When I try the Test it works fine (it is a descending order sort on the _createdAt field).
I then open the list window and the list (data labels in a grid) is not sorted.
Any idea of why this happens?
Best,
Andrea


Sorting issue with database

Posted: Wed May 28, 2014 10:39 am
by Illya Stepanov

Hi Andrea,

How you passing a value of the parameter sort? Using mapping from the UI component (localStorage), or hard-coded?


Sorting issue with database

Posted: Wed May 28, 2014 12:56 pm
by Andrea Spila

Hello Illya,
I have used the UI Component, i.e. I opened the list service and added a parameter sort in the Request tab. Then I went to the Test tab and added "-_createdAt" in the sort field and tested and it is sorted ok.
See screenshot:
Image
Then, when I tested the app the order is ascending...
A


Sorting issue with database

Posted: Fri May 30, 2014 8:49 am
by Kateryna Grynko

Hi Andrea,

Could you please share the app with a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a?


Sorting issue with database

Posted: Wed Jun 11, 2014 7:22 pm
by Kateryna Grynko

Hi Andrea,

Did you solve it?


Sorting issue with database

Posted: Fri Sep 12, 2014 7:23 pm
by Adrian Stoch

I am having the exact same issue. Was there a resolution to this?

To summarize:
I have a sort parameter hard coded in the Query service that works fine on test. But when I open run the query on the page, the sort parameter is ignored.

Here is the sort parameter on -ChatID:
Image

The test results pulls up the biggest ChatID correctly:
Image

But the page shows the lowest ChatID.


Sorting issue with database

Posted: Sat Sep 13, 2014 2:43 am
by Alena Prykhodko

Please share (http://devcenter.appery.io/documentat...) your app with a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a and send us the app name and steps to test. Also tell us service name,


Sorting issue with database

Posted: Tue Oct 07, 2014 3:00 pm
by Kateryna Grynko

Hello guys,

Did you get it working?


Sorting issue with database

Posted: Wed Sep 02, 2015 2:53 am
by George Pillari7662383

I am having this problem as well. Any resolution?


Sorting issue with database

Posted: Wed Sep 02, 2015 12:06 pm
by Serhii Kulibaba

Hello George,

Unfortunately it is not clear enough. Could you please provide more details, screen shots would also help.