Change default columns in Bugs / persist settings.

[Shawn Walbeck]

Hi everyone,

I'm a relatively new user of Agilo for Trac.  I have a question I'm hoping someone can answer for me.

What I'd like to do is click on "Bugs", and see all of the bugs that are assigned to me.  When I go into the columns and add "owner", this solves the issue - temporarily.  If I navigate anywhere else and come back to the Bugs section, my settings for columns is now defaulted again to not show owner.  I have also tried this as applying a filter using my name, but again, leaving this section and coming back defaults to the original filterless, non owner columns. 

Is there an admin setting I can use to set owner as a default column in the Bugs section so that it persists without having to click on column and then select owner every time the Bugs page loads?

I hope this makes sense - thank you for any help!

-Shawn

[Claudio Di Cosmo]

Hi Shawn,

Is it this Bugs section a Trac report?

By the way, for having a list of the Bugs assigned to you, you can create a Trac Report (http://trac.edgewall.org/wiki/TracReports).

The reports are shown on your left bar.

This is the query you should use:

SELECT p.value AS __color__,

   id AS ticket, summary, component, version, milestone, t.type AS type,

   owner, status,

   time AS created,

   changetime AS _changetime, description AS _description,

   reporter AS _reporter

  FROM ticket t

  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'

  WHERE status <> 'closed' AND owner == $USER AND t.type == 'bug'

  ORDER BY CAST(p.value AS integer), milestone, t.type, time

You can also remove the clause "status <> ‘closed’”, if you want to see all the bugs (also the ones that you already completed).

I hope that I answered your question, let me know if you have more issues.

Have a nice day,

Claudio Di Cosmo
Software Engineer
Agilo Software GmbH
Gruenberger Str. 54
10245 Berlin, Germany

claudio...@agilosoftware.com
http://www.agilosoftware.com

Follow us on twitter: http://twitter.com/agiloforscrum, http://twitter.com/agilofortrac

Amtsgericht Charlottenburg: HRB 127146
CEO Marion Eickmann, Andrea Tomasini