Description: Tests for the "order" parameter in SEARCH.
run this test
Designed by: Lynnwood Brown
Topics created for test (Text Item; Number Item; Created; Modified):
format="!$topic; Text Item; Number Item; created date; modified date"
Test searches
Search ordered by Topic Name
This search should be ordered by sequence of values in "Topic Name" field.
Expected
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
Search ordered by Topic Name, reversed
This search should be ordered by reversed sequence of values in "Topic Name" field.
Expected
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
Search ordered by Topic Name, limited to 2
This search should be ordered by sequence of values in "Topic Name" field.
Expected
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
Search ordered by Topic Name, reversed, limited to 2
This search should be ordered by reversed sequence of values in "Topic Name" field.
Expected
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
Search ordered by "Text Item" formfield
This search should be ordered by sequence of values in "Text Item" field.
Expected
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
Search ordered by "Text Item" formfield, reversed
This search should be ordered by reversed sequence of values in "Text Item" field.
Expected
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
Search ordered by "Text Item" formfield, limited to 2
This search should be ordered by sequence of values in "Text Item" field.
Expected
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
Search ordered by "Text Item" formfield, reversed, limited to 2
This search should be ordered by reversed sequence of values in "Text Item" field.
Expected
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
Search ordered by "Number Item" formfield
This search should be ordered by sequence of values in "Number Item" field.
Expected
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
Search ordered by "Number Item" formfield, reversed
This search should be ordered by reversed sequence of values in "Number Item" field.
Expected
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
Search ordered by "Number Item" formfield, limited to 2
This search should be ordered by sequence of values in "Number Item" field.
Expected
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
Search ordered by "Number Item" formfield, reversed, limited to 2
This search should be ordered by reversed sequence of values in "Number Item" field.
Expected
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
Search ordered by date modified
This search should be ordered in sequence of values in "Modified" field (newest first).
Expected
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
Search ordered by date modified, reversed
This search should be ordered in sequence of values in "Modified" field (oldest recently modified first).
Expected
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
Actual
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
Search ordered by date modified, limited to 2
This search should be ordered in sequence of values in "Modified" field (newest first).
Expected
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
Search ordered by date modified, reversed, limited to 2
This search should be ordered in sequence of values in "Modified" field (oldest recently modified first).
Expected
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
Actual
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
Search ordered by date created
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
Search ordered by date created, reversed
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
Search ordered by date created, limited to 2
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
Search ordered by date created, reversed, limited to 2
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23
Search ordered by editby, limited to 2
SearchTestTopic2; Value_2; 2; 14 Dec 2005 - 21:58; 14 Dec 2005 - 22:23; AnnaAncher
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56; KennethLavrsen
Actual
SearchTestTopic2; Value_2; 2; 2005-12-14 - 22:58; 2005-12-14 - 23:23; AnnaAncher
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56; KennethLavrsen
Search ordered by editby, reversed, limited to 2
SearchTestTopic3; Value_3; 1; 14 Dec 2005 - 21:59; 14 Dec 2005 - 21:59; MichaelAncher
SearchTestTopic1; Value_1; 3; 14 Dec 2005 - 21:56; 14 Dec 2005 - 21:56; KennethLavrsen
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 22:59; 2005-12-14 - 22:59; MichaelAncher
SearchTestTopic1; Value_1; 3; 2005-12-14 - 22:56; 2005-12-14 - 22:56; KennethLavrsen