Navigation:  Using AdaptAccounts >     Changing the sort order in a grid

 

 

Tables displayed in a grid format may be in a fixed sort order or in a sort order that you can change. When all column titles are colored “black” then the grid is in a fixed sort order.

 

When some column titles are colored "blue" then you can change the sort order. A column whose title is colored “green” indicates the primary sort order for the grid. When you first view the grid it is sorted by the primary key, which is typically a single column, such as CustomerID. Its title is colored “green”. The primary key is always the “tie-breaker” in any multi-column sort order. This means it is always the final sort key in a multi-column sort order. That is, sorting by any other columns in this example such as “by State by City” means “by State by City by CustomerID”.

 

When a column’s title is colored “blue” you can click that title to extend the sort order to include that column. It will then be colored “red” to indicate it is now used in the sort order.

 

For example, clicking the City title when you first view this grid means sort this grid “by City by CustomerID”. That is, the CustomerID is included as the final sort key. To extend this sort order to be “by State by City by CustomerID” click the State title. Note that the last title you click will be the first column in the sort order.

 

To restore the original sort order to be simply the primary key then click the title (which is colored “green”) for that primary key. For example, to restore the original sort order in this example just click the CustomerID title.