Bug #38666 Saved Search broken in 2.1.1, "sort_by=iss_pri_id", should be "sort_by=pri_rank"
Submitted: 8 Aug 2008 14:08 Modified: 1 Jan 2011 17:47
Reporter: Ken Lignelli Email Updates:
Status: Won't fix Impact on me:
None 
Category:Eventum Severity:S3 (Non-critical)
Version:2.1.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: priority, rank, search, sort

[8 Aug 2008 14:08] Ken Lignelli
Description:
My old saved search (from Eventum version 1.x) looks like this:
http://localhost/eventum/list.php?cat=search&priority=0&keywords=&users=&category=0&status...

The new search I created in v2.1.1 looks like this:
http://localhost/eventum/list.php?cat=search&priority=0&keywords=&users=&category=0&status...

You'll notice that the "sort_by" string has changed from:
"sort_by=pri_rank"
to
"sort_by=iss_pri_id"

The old way works - it sorts my Issues List correctly by Priority Rank.
The new way (v2.1.1) fails - it does not sort my Issues list at all (comes out in default sort order)

How to repeat:
- Create a new saved search under "Advanced Search" which simply shows all issues, sorted by Priority, Ascending.
- Run saved search
- notice that the column header in Issues List page does not have the "sorting triangle" for Priority.

Suggested fix:
I manually changed the v2.1.1 URL to use "sory_by=pri_rank" and it worked.

Found bug in file:
adv_search.tpl.html

http://svn.mysql.com/fisheye/browse/eventum-gpl/eventum/templates/adv_search.tpl.html?r=36...

Code:

<td>
<span class="default">{t}Sort By{/t}:</span><br />
<select name="sort_by" class="default">
<option value="iss_pri_id" {if $options.cst_sort_by == "iss_pri_id"}selected{/if}>{t}Priority{/t}</option>
<option value="iss_id" {if $options.cst_sort_by == "iss_id"}selected{/if}>{t}Issue ID{/t}</option>
<option value="sta_rank" {if $options.cst_sort_by == "sta_rank"}selected{/if}>{t}Status{/t}</option>
<option value="iss_summary" {if $options.cst_sort_by == "iss_summary"}selected{/if}>{t}Summary{/t}</option>
<option value="last_action_date" {if $options.cst_sort_by == "last_action_date"}selected{/if}>{t}Last Action Date{/t}</option>
</select>
</td>

should be fixed to:

<td>
<span class="default">{t}Sort By{/t}:</span><br />
<select name="sort_by" class="default">
<option value="pri_rank" {if $options.cst_sort_by == "pri_rank"}selected{/if}>{t}Priority{/t}</option>
<option value="iss_id" {if $options.cst_sort_by == "iss_id"}selected{/if}>{t}Issue ID{/t}</option>
<option value="sta_rank" {if $options.cst_sort_by == "sta_rank"}selected{/if}>{t}Status{/t}</option>
<option value="iss_summary" {if $options.cst_sort_by == "iss_summary"}selected{/if}>{t}Summary{/t}</option>
<option value="last_action_date" {if $options.cst_sort_by == "last_action_date"}selected{/if}>{t}Last Action Date{/t}</option>
</select>
</td>
[1 Jan 2011 17:47] Valeriy Kravchuk
As Oracle no longer sponsors or coordinates active development of the Eventum software, interested parties should report bugs at https://bugs.launchpad.net/eventum