column selector / saving columns per query

[David Miller]

robzilla wrote:

> I'm working on revamping the "Choose Columns" functionality in my 
> installation of Bugzilla.  I want to eventually submit a patch since it 
> cleans things up real nice and provides functionality for saving 
> displayed columns per query, but since it changes a couple things, I 
> wanted some feedback.

This sounds pretty cool.  FWIW, I did something very similar (but it was 
still based off the "Change Columns" link) a while back for Zippy, and 
AOL did contribute the code.  It's sitting in a bug somewhere in 
Bugzilla right now.  Clicking the Change Columns link pops up a window 
with three list boxes in it.  The left one has a list of all of the 
columns that are available that you don't currently have in your column 
list.  The middle one is your current column list, and the right hand 
one is the columns you're sorting on.  So it let you pick the order of 
the columns and your sort order as well.  The middle and right-hand 
columns allowed you to move items up and down in the list to change the 
order, and double-clicking on an item in the sort list would change the 
arrow on the end of it to indicate the sort direction.  There were 
arrows between the columns to move items between columns.  Submitting it 
would resubmit the query in the parent window with the columns and sort 
list in the URL, so it would save with the query if you saved the query.

This was, of course, heavily javascript based, but it worked sweet, and 
you still got the old change columns page if you didn't have javascript.

/me pokes around...  https://bugzilla.mozilla.org/show_bug.cgi?id=164009

I'm not positive that all of the necessary code is there...  I have the 
original to pull from here somewhere, and permission to use it provided 
it gets sanitized.

I always wanted a way to choose columns before running the query as 
well, and this doesn't outright provide that.  I don't think I'd want to 
give up changing the columns after the fact though.  Perhaps we can 
combine our two patches?

-- 
Dave Miller                                   http://www.justdave.net/
System Administrator, Mozilla Foundation       http://www.mozilla.org/
Project Leader, Bugzilla Bug Tracking System  http://www.bugzilla.org/