Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Category Sorting - Non alphabetical

  Asked By: Code    Date: Sep 16    Category: Sharepoint    Views: 2126

Trying to sort categories but in non-alphabetical order.
Any ideas?



1 Answer Found

Answer #1    Answered By: Bernice Puckett     Answered On: Sep 16

Does anyone have an idea to display the categories  in non-
alphabetical order?

The "Using Microsoft Sharepoint Portal Server" p. 111 says that the
categories are stored in SPS in the order  that they are created. I
think that it has been changed since the book has been published
since the categories on my portal display in alphabetical  order.

I think that the SQL query option "ORDER BY DAV:displayname" is the
one that creates the collection ordered by name. I don't know what
other option we could use. I was thinking about adding a number
keyword that would be the order for the display and change the SQL
query... Anyone who could help here?

strTopCategoriesSqlQuery = _
" SELECT " & vbCRLF & _
" ""DAV:href"", ""DAV:displayname"", ""DAV:contentclass""
, ""urn:schemas-microsoft-com:office:office#Description"" " & vbCRLF
& _
() & "/" & GetWorkspacePropertyByUri(g_cdostrURI_CategoriesFolder) &
strCategoryPath & """')" & vbCRLF & _
" WHERE ""DAV:contentclass"" = 'urn:content-
classes:categoryfolder'" & vbCRLF & _
" ORDER BY ""DAV:displayname"" ASC" & vbCRLF

Didn't find what you were looking for? Find more on Category Sorting - Non alphabetical Or get search suggestion and latest updates.