TestCaseAutoSearchSort < TestCases

NOTE: This is the TestCases web. You cannot edit any topic named "TestCase..." or "Web..." in this web, you can only create new topics. Any topics you do create that are not checked into subversion may be deleted by anyone, at any time.
Tags: view all tags
Description: Tests for the "sort" parameter in SEARCH.

[[%SCRIPTURL{"view"}%/%WEB%/%TOPIC%?test=compare&amp;debugenableplugins=TestFixturePlugin&skin=pattern][run this test]]

Designed by: Lynnwood Brown

Topics created for test (Text Item; Number Item; Created; Modified):
   * 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)

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._ %BR%
---++++ Expected
<!-- expected rex SORT BY TOPIC NAME -->
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="topic" }%
<!-- /actual -->

---+++ Search ordered by Topic Name, reversed
_This search should be ordered by *reversed* sequence of values in "Topic Name" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY REV TOPIC NAME -->
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="topic" reverse="on" }%
<!-- /actual -->

---+++ Search ordered by Topic Name, limited to 2
_This search should be ordered by sequence of values in "Topic Name" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY TOPIC NAME LIMITED TO 2 -->
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="topic" limit="2"}%
<!-- /actual -->

---+++ Search ordered by Topic Name, reversed, limited to 2
_This search should be ordered by *reversed* sequence of values in "Topic Name" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY REV TOPIC NAME LIMITED TO 2 -->
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="topic" reverse="on" limit="2"}%
<!-- /actual -->

---+++ Search ordered by "Text Item" formfield
_This search should be ordered by sequence of values in "Text Item" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY TEXT ITEM -->
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="formfield(Text Item)" reverse="0" }%
<!-- /actual -->

---+++ Search ordered by "Text Item" formfield, reversed
_This search should be ordered by *reversed* sequence of values in "Text Item" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY REV TEXT ITEM -->
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="formfield(Text Item)" reverse="on" }%
<!-- /actual -->
<!-- yes, reverse="off". That's what search does, it interprets "off" as "on" -->


---+++ Search ordered by "Text Item" formfield, limited to 2
_This search should be ordered by sequence of values in "Text Item" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY TEXT ITEM LIMITED TO 2 -->
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="formfield(Text Item)" reverse="0" limit="2"}%
<!-- /actual -->

---+++ Search ordered by "Text Item" formfield, reversed, limited to 2
_This search should be ordered by *reversed* sequence of values in "Text Item" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY REV TEXT ITEM LIMITED TO 2 -->
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="formfield(Text Item)" reverse="on" limit="2"}%
<!-- /actual -->
<!-- yes, reverse="off". That's what search does, it interprets "off" as "on" -->

---+++ Search ordered by "Number Item" formfield
_This search should be ordered by sequence of values in "Number Item" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY NUMBER ITEM -->
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="formfield(Number Item)"  }%
<!-- /actual -->

---+++ Search ordered by "Number Item" formfield, reversed
_This search should be ordered by *reversed* sequence of values in "Number Item" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY REV NUMBER ITEM -->
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="formfield(Number Item)" reverse="1"}%
<!-- /actual -->

---+++ Search sorted by "Number Item" formfield, limited to 2
_This search should be sorted by sequence of values in "Number Item" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY NUMBER ITEM LIMITED TO 2 -->
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="formfield(Number Item)" limit="2" }%
<!-- /actual -->

---+++ Search sorted by "Number Item" formfield, reversed, limited to 2
_This search should be sorted by *reversed* sequence of values in "Number Item" field._ %BR%
---++++ Expected
<!-- expected rex SORT BY REV NUMBER ITEM LIMITED TO 2 -->
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="formfield(Number Item)" reverse="1" limit="2"}%
<!-- /actual -->

---+++ Search sorted by date modified
_This search should be sorted in sequence of values in "Modified" field (newest first)._ %BR%
---++++ Expected
<!-- expected rex SORT BY DATE MODIFIED -->
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="modified" reverse="" }%
<!-- /actual -->

---+++ Search sorted by date modified, reversed
_This search should be sorted in sequence of values in "Modified" field (oldest recently modified first)._ %BR%
---++++ Expected
<!-- expected rex SORT BY REV DATE MODIFIED -->
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="modified" reverse="on" }%
<!-- /actual -->

---+++ Search sorted by date modified, limited to 2
_This search should be sorted in sequence of values in "Modified" field (newest first)._ %BR%
---++++ Expected
<!-- expected rex SORT BY DATE MODIFIED LIMITED TO 2 -->
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="modified" reverse="" limit="2"}%
<!-- /actual -->

---+++ 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)._ %BR%
---++++ Expected
<!-- expected rex SORT BY REV DATE MODIFIED LIMITED TO 2 -->
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="modified" reverse="on" limit="2"}%
<!-- /actual -->

---+++ Search sorted by date created
<!-- expected rex SORT BY DATE CREATED -->
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="created" }%
<!-- /actual -->
---+++ Search sorted by date created, reversed
<!-- expected rex SORT BY REV DATE CREATED -->
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="created" reverse="on"}%
<!-- /actual -->

---+++ Search sorted by date created, limited to 2
<!-- expected rex SORT BY DATE CREATED LIMITED TO 2 -->
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="created" limit="2"}%
<!-- /actual -->
---+++ Search sorted by date created, reversed, limited to 2
<!-- expected rex SORT BY REV DATE CREATED LIMITED TO 2 -->
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59<br />
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date<br />" sort="created" reverse="on" limit="2"}%
<!-- /actual -->


---+++ Search sorted by editby, limited to 2
<!-- expected rex SORT BY DATE CREATED LIMITED TO 2 -->
SearchTestTopic2; Value_2; 2; 2005-12-14 - 21:58; 2005-12-14 - 22:23; <nop>AnnaAncher<br />
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56; <nop>KennethLavrsen<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date; <nop>$wikiname<br />" sort="editby" limit="2"}%
<!-- /actual -->
---+++ Search sorted by editby, reversed, limited to 2
<!-- expected rex SORT BY REV DATE CREATED LIMITED TO 2 -->
SearchTestTopic3; Value_3; 1; 2005-12-14 - 21:59; 2005-12-14 - 21:59; <nop>MichaelAncher<br />
SearchTestTopic1; Value_1; 3; 2005-12-14 - 21:56; 2005-12-14 - 21:56; <nop>KennethLavrsen<br />
<!-- /expected -->
---++++ Actual
<!-- actual -->
%SEARCH{ "SearchTestTopic" scope="topic" scope="topic" nototal="on" nosearch="on" header="" format="!$topic; $formfield(Text Item); $formfield(Number Item); $createdate; $date; <nop>$wikiname<br />" sort="editby" reverse="on" limit="2"}%
<!-- /actual -->
WYSIWYG | More topic actions
Topic revision: r1 - 2021-01-06 - TWikiGuest