settings are stored using the framework, they do not need sprocs in its data provider

sort settings are stored in table TabModuleSettings table, valid keys for sorting are UDT_SortField (fieldID) and UDT_SortOrder ("ASC", "DESC")

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

Okay.  I can see that the values are indeed getting saved to the DB now.  The field that I want to sort by is ID = 1.  Here is what I see in the table.

UDT_Paging - (empty)
UDT_RenderingMethod - DataGrid
UDT_sortfield - 1
UDT_sortorder - ASC
UDT_UsedCssClasses - UDT
UDT_XslPreDefinedStyleSheet - ~/DesktopModules/UserDefinedTable/XslStyleSheets/BasicTable.xsl

The UDT contains numerous rows of contacts where the first field (Name, ID = 1) is the last name and first name, separated by a comma.  When I think that I have saved the sort, there is a name "Clayton" that continues to appear as the first name in the list and then a name "Crafton" that continues to appear at the bottom of the list.  When I attempt to add another row to test out the sort (just in case those records are not any good for some reason), the new name appears at the bottom of the listing.

Here is what the Name column info looks like:

FieldTitle - Name
Visible - True
FieldOrder - 0
FieldType - String
Required - False

I am unsure of what else to check to get this to work right. 

---

Will Strohl

Upendo Ventures DNN experts since 2003 Official provider of the Hotcakes Commerce Cloud and SLA support

1. Agreed.

2. Renamed it to "Teacher Name" and "Teacher" and received the same result both times.

3. This may be correct.  The sort has always worked when clicking the column names, but not on initial page load.

4. I saw that post.  :)  Thanks.

5. It is.

---

Will Strohl

Upendo Ventures DNN experts since 2003 Official provider of the Hotcakes Commerce Cloud and SLA support