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

 
 

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

Submitted by:  Steve White <Stevan_White>
Submitted on:  Sun 20 Nov 2011 10:08:35 AM UTC  
 
Category: Trackers (bugs, support, tasks...)Priority: 5 - Normal
Severity: 1 - WishStatus: Confirmed
Assigned to: Pavel Kharitonov <ineiev>Operating System: None
Open/Closed: Open

Add a New Comment (Rich MarkupRich Markup):
   

You are not logged in

Please log in, so followups can be emailed to you.

 

(Jump to the original submission 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.

Pavel Kharitonov <ineiev>
Site AdministratorIn charge of this item.
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).

Pavel Kharitonov <ineiev>
Site AdministratorIn charge of this item.
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?

Pavel Kharitonov <ineiev>
Site AdministratorIn charge of this item.
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?

Pavel Kharitonov <ineiev>
Site AdministratorIn charge of this item.
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>
Site Administrator
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 File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

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

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 3 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Sat 09 Aug 2014 07:09:58 AM UTCineievAssigned tomjflick=>ineiev
    Mon 28 Nov 2011 06:57:21 AM UTCmjflickStatusNone=>Confirmed
      Assigned toNone=>mjflick

    Back to the top


    Powered by Savane 3.1-cleanup