Sort rows by posted.

[DanGarrett]

Hey Guys,

I have a system posting into a database but I want to be able to pull rows from the DB in a different order, like by date/time.

Basically to use the data organised from newest to oldest.

Any ideas?

[Kateryna Grynko]

Hi Dan,

To sort rows you would need to add request parameter "sort". As a value use the name of the column you want to sort by.
This should be helpful: http://docs.appery.io/documentation/b...

[DanGarrett]

Hi Katya,

I've added the request paramater "sort" and the value as "_createdAt" but it makes no changes to the result.

[Kateryna Grynko]

Hi Dan,

Request parameter "sort" works for us:

If you need descending sorting then in parameter sort add minus sign:
"-_createdAt"

[DanGarrett]

Am I missing something?

[Kateryna Grynko]

Please check the data output on the collection management page. For the output of the list from newest to oldest you don't need "minus" before the column nameThat is, sort: "_createdAt".