2. Suggestions
  3. Provide an "Initial OrderBy" property to Field Header in List page
This topic is locked

Provide an "Initial OrderBy" property to Field Header in List page

 		9/6/2013 3:22:07 AM
Suggestions
K
 kunitone author



[font="arial"][size="2"][color="#222222"]Usually we want to see such list in descending order of such numbers.[/size]
[font="arial"][size="2"]

[font="arial"][size="2"] [/size]
[font="arial"][size="2"] [/size]
[font="arial"][size="2"][color="#222222"]If the property is set to "Descending" and the Field Header is clicked, the list in the List page is sorted in descending order at first.[/size]
[font="arial"][size="2"]Does this make sense?[/size]
Sergey Kornilov admin 9/6/2013

The initial order can be specified in SQL Query:

select ...

from ...

order by "Sales Value" asc, "Sales Quantity" desc
K
 		kunitone author 9/8/2013

Hello
Thank you for your reply. Your idea works if the list has only one numeric column to be sorted descending.

But usually our list has multiple numeric columns to be sorted descending interactively.
The use case is,

  1. First the list is sorted descending order by Sales Volume.
  2. Next a user clicks Sales Quantity column title to sort the list in descending order by [size="2"]Sales Quantity.[/size]
  3. Next a user clicks Profit Ratio column title to sort the list in descending order by Profit Ratio[size="2"].[/size]
    >

    The initial order can be specified in SQL Query:

select ...

from ...

order by "Sales Value" asc, "Sales Quantity" desc