Office Live Small Business Community Forums

How to do sorting by date in the list posted on public website

Last post 03-19-2008 12:10 PM by John Perkins. 2 replies.
Page 1 of 1 (3 items)
Sort Posts:
03-19-2008 11:33 AM
Kent Chig Joined on 03-19-2008 Posts 2
How to do sorting by date in the list posted on public website

I have some news posted on public site, but I prefer to sort the date by descending order.  I have tries to sort the date by descending order in workspace successfully, but cannot work on public web site.

For example,

2008/01/05  news 1

2008/02/01 New 3

2008/01/31 news 2

sort to

2008/02/01 new 3

2008/01/31 new 2

2008/01/05 New 1

on Public website using by List module of web design tool.

Any Ideas?

Thank you

03-19-2008 12:06 PM In reply to
royster Joined on 02-12-2008 Posts 1,478
Re: How to do sorting by date in the list posted on public website

Hi Kent

You need to creater or modify the view that you used to publish the list with according to the order you want in the business application.  Once you have saved the view with the sorting that you want, you will need to go back to the list publisher module on your webpage and reload the list view schema (just select another list and then select the list that you want to publish again.  Make sure you select the correct view that you want (the one that has the corect sorting order).

Hope this helps!
Royster
PartArt: A fresh approach to viewing new posts from the Office Live Community
Try it out now!

03-19-2008 12:10 PM In reply to
John Perkins Joined on 02-12-2008 New Hampshire Posts 77
Re: How to do sorting by date in the list posted on public website

XSLT 1.0 is known to have very poor date handling.

My guess and that is all it is what you think you are sorting is actually represented in a much different format from what you see when you "print" it.

When you are sorting in the private view you are using SQL and when you are sorting in the public view you are using XSLT. This is my impression and may not be a statement of fact but this is my working model.

I ran into this issue also and have decided to leave it for another day when I care enough to try to address the issue.

The lack of access to standard Micorosoft extensions of XSLT 1.0 in MOLB has eliminated that as an avenue from using these extension to address know weaknesses in XSLT.

MOLB will be a much better place to do web design if we have the ability to access these extensions. The reason Microsoft created these extensions to XSLT 1.0 is because they realized that the extensions were needed especially when using XSLT on the server or in the browser for web related activities.

When it comes to XSLT, at the moment we are left with a car that only has 1 gear and that is reverse.

 

 

 

 

Advertisement