List View - Editable Template

From SmartWiki

You can now edit the template in list view settings (somewhat like report template). Go to: 1) Settings 20) List View 3) Template.

This also allows you to change a string field into a numeric field to sort. For example you are trying to arrange your sort order based on fields that have integer value, but the sort is not working properly is because its 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.