Question

I am using a Form to create pages with title Abcd2026Jul05

Further search these topics using %SEARCH{ "^Abcd200" regex="on" scope="topic" reverse="off" order="modified" nosearch="on" nototal="on" header="" format="   * [[$topic]]" }%

After searching i get the topics in the following order

• Abcd2005Jun10
• Abcd2005Jun21
• Abcd2005Jul01
• Abcd2005Jun17

Where as i want the topics to be arranged by first on the month then date basis, like this

• Abcd2005Jul01
• Abcd2005Jun21
• Abcd2005Jun17
• Abcd2005Jun10

Is there a way i can do this. Any help will be appreciated.

Environment

-- BinuAbraham - 06 Jul 2005

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

You can easily solve the sorting issue by using dates that are sortable, e.g. the MeetingMinutes applications uses dates such as "MeetingMinutes2005x06x10".

Alternatively, use TWikiForms in your topics with a field named "Date" that has a sortable date such as "2005/06/10". Use a TWikiSearch with =order="formfield(Date)" to sort the search results.

Yet another option is to sort by order="created". This assumes that the topics are created in chronological order.

-- PeterThoeny - 07 Jul 2005