[[Image:Sortordertab.png]]
==Defining a List View Template==
You can customize the list view by clicking on the '''Template''' button at the bottom of the '''List View''' page.
Note: a basic understanding of HTML may be required to make changes to the List View Templates.
* The '''Header''' section can be used to adjust the column headings. You can change the formatting, as well as the column heading displayed.
* The '''Columns''' section controls the display of the actual record list view.
* The '''Order Clause''' allows you to manage the sequence of records in a more complex way than on the '''Set Order''' page.
::''For example, if you are trying to arrange your sort order based on a field that has an integer value the sort may not work properly if the data is stored as string. To make this a numeric value to sort do the following:
:::* In the list view template go to the section of 'Order Clause' and find the field that your looking for based on custom field id.
:::* Change the value from ''cf_967517 desc'' to ''tbl_967517.valuestr*1 desc''; which converts it to a numeric value now.
==See Also==
