mainSavannah Administration - Support: sr #107879, bug report listings: configurable...

 
 

sr #107879: bug report listings: configurable columns, more options

Submitter:  Steve White <Stevan_White>
Submitted:  Sun 20 Nov 2011 10:08:35 AM UTC
   
 
Category:  Savannah trackers - bugs, tasks, etc. Priority:  5 - Normal
Severity:  1 - Wish Status:  Done
Privacy:  Public Assigned to:  ineiev
Operating System:  None Open/Closed:  Closed
* Mandatory Fields

Add a New Comment Rich Markup
   

Jump to the original submission

Sat 09 Aug 2014 06:17:05 PM UTC, comment #13: 

Thanks ! It works great now.

All the best,

Luis Falcon <meanmicio>
Sat 09 Aug 2014 04:51:30 PM UTC, comment #12: 

Yes, it was related; thanks for report, now it should work.

Ineiev <ineiev>
Site Administrator
Sat 09 Aug 2014 11:24:16 AM UTC, comment #11: 

Hi Pavel !

Don't know whether is related, but it seems that there is an issue with the sorting on the bugs and tasks.

Both listing show the oldest first, and clicking on the columns to sort won't work.

Thanks !

Luis Falcon <meanmicio>
Sat 09 Aug 2014 07:09:58 AM UTC, comment #10: 

Hello, Steve!

> I broke my bug listing. Just clicking around on those fields, it got so if I use my custom view, the bug list just presents an error message:
>
> Notice: Undefined index: date_op in /usr/src/savane/frontend/php/include/trackers_run/browse.php on line 684 Notice: Undefined index: date in /usr/src/savane/frontend/php/include/trackers_run/browse.php on line 685 db_query: SQL query error...


I've just fixed this bug (the request of sorting is ignored if the column isn't selected for output).

Ineiev <ineiev>
Site Administrator
Thu 07 Aug 2014 02:00:28 PM UTC, comment #9: 

Hello, Luis!

I visit https://savannah.gnu.org/bugs/?group=health; in the "Browse with the" ... "query form..." combo box I select "release" (other options are "Basic", "Advanced", "Votes", "By Date"). I push "Apply".

At this point, I see the table with "Item ID" and "Release" columns (of course, you can add more fields to the query form), and when I visit the links in the header of the table, the results are sorted accordingly.

Isn't it what you expect?

Ineiev <ineiev>
Site Administrator
Wed 06 Aug 2014 09:50:47 PM UTC, comment #8: 

Thanks a lot, Pavel !

I think of the "tree view" as the initial, summarized view that we get showing all the records, with the field names as columns.

My idea is to be able to also sort by release number from that "tree view".

Most probably I'm missing something and I'm not seeing how to get it.

Thanks again to you and Karl for your time and keeping Savannah in good shape :)

All the best,

Luis Falcon <meanmicio>
Wed 06 Aug 2014 02:26:48 PM UTC, comment #7: 

Hello, Luis!

I've just fixed that "Undefined variable: TFCW_severity..." error output.

I'm not sure what tree view is; when I check the "Use as an Output Column" box in the "Release" line on the "Edit Query Form" page, the query output does include the release. do I miss something?

Ineiev <ineiev>
Site Administrator
Tue 15 Jul 2014 11:05:21 AM UTC, comment #6: 

Hello

Just a quick update on this. I would like to search on issues/bugs associated to an specific GNU Health version.

Is there a way to show the release on the tree view ?

Also, the query generator (query edit form) I get the following error :

Notice: Undefined variable: TFCW_severity in /usr/src/savane/frontend/php/include/trackers_run/admin/editqueryforms.php on line 176 Notice: Undefined variable: TFCW_bug_group_id in /usr/src/savane/frontend/php/include/trackers_run/admin/editqueryforms.php on line 176 Notice: Undefined variable: TFCW_release_id in /usr/src/savane/frontend/php/include/trackers_run/admin/editqueryforms.php on line 176 Notice: Undefined variable: TFCW_custom_tf1 in /usr/src/savane/frontend/php/include/trackers_run/admin/editqueryforms.php on line 176


Thanks a lot !

Best,
Luis

Luis Falcon <meanmicio>
Mon 28 Nov 2011 06:57:21 AM UTC, comment #5: 

Added to to-do list.

Michael J. Flickinger <mjflick>
Sun 20 Nov 2011 07:43:51 PM UTC, comment #4: 

That happens when you leave the form sorting according to column X, then in the custom view, remove column X from the display.

The code should check for this situation, and revert to ordering by the displayed column of highest priority.

Steve White <Stevan_White>
Sun 20 Nov 2011 07:35:31 PM UTC, comment #3: 

I spoke too soon.

I broke my bug listing.  Just clicking around on those fields, it got so if I use my custom view, the bug list just presents an error message:

Notice: Undefined index: date_op in /usr/src/savane/frontend/php/include/trackers_run/browse.php on line 684 Notice: Undefined index: date in /usr/src/savane/frontend/php/include/trackers_run/browse.php on line 685 db_query: SQL query error Unknown column 'user_submitted_by.user_name' in 'order clause' in [SELECT DISTINCT bugs.group_id,bugs.priority,bugs.privacy,bugs.status_id,bugs.submitted_by ,bugs.bug_id,bugs.summary,bugs.resolution_id,user_assigned_to.user_name AS assigned_to,bugs.date FROM bugs ,user user_assigned_to WHERE bugs.group_id='1405' AND (bugs.spamscore < '5' OR submitted_by='18884') AND bugs.status_id IN ('1') AND user_assigned_to.user_id=bugs.assigned_to ORDER BY user_submitted_by.user_name ASC LIMIT 0,100]

Steve White <Stevan_White>
Sun 20 Nov 2011 07:27:32 PM UTC, comment #2: 

Hey Karl,

The "Edit Query Forms" feature does in fact do much of what I was asking for.  I had never tried it, and had no idea what it did.  It's not exactly obvious...

This takes care of complaints
  (1)
  (4)

However the issues with dates remain.

  2) The format of the date fields being too long.
     Either provide a way to change the formatting, or just
     display it as YYYY-MM-DD.

  3) It is sometimes pretty important to see which bugs have
     been recently touched.  There seems to be no way to get
     at this information.

Thanks!

Steve White <Stevan_White>
Sun 20 Nov 2011 06:51:01 PM UTC, comment #1: 

Hi Steve,

On the freefont project page, go to the bugs menu, then configure, and there are items like "select fields", which has tons of "custom" fields, and "edit query forms" to define new searches, etc.  I admit I've never used them, but perhaps something in there would help?  Or if you've already tried it and it is inadequate, just say so.  i wasn't sure from your description.

they certainly won't cover everything in your message, but maybe some of it?

hopefully,
k

Karl Berry <karl>
Site Administrator
Sun 20 Nov 2011 10:08:35 AM UTC, original submission:  

Hi,

This has bugged me for a long time, and I know it seems minor, but let's get it out.

When looking through a long list of bugs, the given columns in the bug report lists is often inadequate.  As far as I know it's rigid, too.

1) It would be nice to choose which columns are displayed.

2) The date display, showing full date and time and timezone
      Wed 16 Nov 2011 04:01:43 PM CET
   is usually way too much information in a small screen.
   A compact representation of just the date would be better
      2011-11-16

3) It is often important to see which reports have been touched recently.  So it would be good to have a separate column showing the date of the last change.

4) The original reporter's ID is also of interest.

Thanks!


Steve White <Stevan_White>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by ineiev (Posted a comment)
  • -email is unavailable- added by meanmicio (Posted a comment)
  • -email is unavailable- added by mjflick (Posted a comment)
  • -email is unavailable- added by karl (Posted a comment)
  • -email is unavailable- added by Stevan_White (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 6 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2016-01-22 ineiev StatusReady For Test Done
    2016-01-22 ineiev StatusConfirmed Ready For Test
        Open/ClosedOpen Closed
    2014-08-09 ineiev Assigned tomjflick ineiev
    2011-11-28 mjflick StatusNone Confirmed
        Assigned toNone mjflick

    Back to the top

    Powered by Savane 3.13-02a9.
    Corresponding source code