Roundup Tracker - Issues

Issue 655702

classification
RDBMS backends can't sort on multilink
Type: Severity: normal
Components: None Versions:
process
Status: closed fixed
:
: : abrandl, myers_carpenter, richard
Priority: normal :

Created on 2002-12-18 12:47 by abrandl, last changed 2004-04-05 07:20 by richard.

Messages
msg551 Author: [hidden] (abrandl) Date: 2002-12-18 12:47
The "sort on" listbox  may contain items that are not present in
the database.  If  i want to e.g. sort on topic, i get an error message
complaining about the non-existing column _topic.

The same problem occurs with the other listbox, "group on".
These listboxes should IMHO only contain the items that
correspond to columns in the database.

Regards,

Albert
msg552 Author: [hidden] (richard) Date: 2002-12-18 23:52
Logged In: YES 
user_id=6405

The list of properties to sort/group on is generated using the list of 
properties on the context class (typically "issue"). 
 
Have you modified the schema or template in any way? 
 
msg553 Author: [hidden] (abrandl) Date: 2002-12-19 07:38
Logged In: YES 
user_id=540690

No, I haven't modified the schema or the template.
msg554 Author: [hidden] (richard) Date: 2003-01-08 05:02
Logged In: YES 
user_id=6405

This is only a problem with the relational database backends -  
they may not sort or group on a multilink property. There is no 
really easy fix for this - except perhaps for someone to spend 
some time looking into handling sort/group for Multilinks in the 
rdbms backends. 
 
If it's really annoying you, feel free to hard-code the list of 
sort/group properties that are valid for your tracker. 
 
msg555 Author: [hidden] (myers_carpenter) Date: 2004-04-01 19:21
Logged In: YES 
user_id=335935

I would really like to be able to group on a topic/keyword,
even if an issue shows up twice in the results.  
msg556 Author: [hidden] (richard) Date: 2004-04-02 03:55
Logged In: YES 
user_id=6405

I've just gotta figure the sql-fu to make it work in sql databases that 
don't have decent joining capabilities. 
 
Meh, maybe I'll just code a python-side implementation and be done 
with it. Better than nothing, I reckon. 
msg557 Author: [hidden] (richard) Date: 2004-04-05 07:20
Logged In: YES 
user_id=6405

I implemented it the hard way (though with a little smarts)... 
 
History
Date User Action Args
2002-12-18 12:47:56abrandlcreate