Description: Tests for the "sort" 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; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21: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; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21: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; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22: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; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22: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; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21: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; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21: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; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22: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; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22: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; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21: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; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
Search sorted by "Number Item" formfield, limited to 2
This search should be sorted by sequence of values in "Number Item" field.
Expected
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Search sorted by "Number Item" formfield, reversed, limited to 2
This search should be sorted by reversed sequence of values in "Number Item" field.
Expected
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Search sorted by date modified
This search should be sorted in sequence of values in "Modified" field (newest first).
Expected
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Search sorted by date modified, reversed
This search should be sorted in sequence of values in "Modified" field (oldest recently modified first).
Expected
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
Actual
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
Search sorted by date modified, limited to 2
This search should be sorted in sequence of values in "Modified" field (newest first).
Expected
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
Search sorted by date modified, reversed, limited to 2
This search should be sorted in sequence of values in "Modified" field (oldest recently modified first).
Expected
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
Actual
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
Search sorted by date created
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
Search sorted by date created, reversed
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
Search sorted by date created, limited to 2
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Actual
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Search sorted by date created, reversed, limited to 2
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23
Search sorted by editby, limited to 2
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23; AnnaAncher
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56; KennethLavrsen
Actual
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23; AnnaAncher
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56; KennethLavrsen
Search sorted by editby, reversed, limited to 2
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59; MichaelAncher
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56; KennethLavrsen
Actual
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59; MichaelAncher
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56; KennethLavrsen