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