Sorting issue with database

This forum contains topics that were moved from Get Satisfaction
Andrea Spila
Posts: 0
Joined: Tue May 20, 2014 12:37 pm

Sorting issue with database

Post 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

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

Sorting issue with database

Post by Illya Stepanov »

Hi Andrea,

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

Andrea Spila
Posts: 0
Joined: Tue May 20, 2014 12:37 pm

Sorting issue with database

Post 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

Kateryna Grynko
Posts: 0
Joined: Thu Nov 15, 2012 9:13 am

Sorting issue with database

Post by Kateryna Grynko »

Hi Andrea,

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

Kateryna Grynko
Posts: 0
Joined: Thu Nov 15, 2012 9:13 am

Sorting issue with database

Post by Kateryna Grynko »

Hi Andrea,

Did you solve it?

Adrian Stoch
Posts: 0
Joined: Thu Jul 31, 2014 3:09 pm

Sorting issue with database

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

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

Sorting issue with database

Post 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,

Kateryna Grynko
Posts: 0
Joined: Thu Nov 15, 2012 9:13 am

Sorting issue with database

Post by Kateryna Grynko »

Hello guys,

Did you get it working?

George Pillari7662383
Posts: 0
Joined: Sun Jul 26, 2015 9:03 pm

Sorting issue with database

Post by George Pillari7662383 »

I am having this problem as well. Any resolution?

Serhii Kulibaba
Posts: 147
Joined: Tue Aug 27, 2013 1:47 pm

Sorting issue with database

Post by Serhii Kulibaba »

Hello George,

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

Post Reply