Mailing List Archive: Trac: Users

re-ordering reports and queries

Index | Next | Previous | View Threaded

christian.unger at mac

Jun 2, 2009, 4:31 AM

Post #1 of 5 (200 views)
Permalink

re-ordering reports and queries

so we have added and deleted reports over time.

and I want to put them in a certain order.

every report obviosuly got it's own report ID

now some queries show this id under e.g. report=7

if I change this to a different number I get presented withan error
like so:

Error: When specified, the report number should be "29".

even when earlier slots like 9,10,11 and so on are free trac tries to
append the new report at the end of the report list rather than
inserting it in the free slot which I specified in the query.

What gives?

__
cu
christian unger

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users[at]googlegroups.com
To unsubscribe from this group, send email to trac-users+unsubscribe[at]googlegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

denysmichel at googlemail

Jun 26, 2009, 1:30 AM

Post #2 of 5 (166 views)
Permalink

Re: re-ordering reports and queries [In reply to]

I have the same problem: I want to put some logical order in my long
list of reports.

It would be nice if the reports had a property "Display Order" that
could be changed in the edit screen of a report.

Meanwhile, I will investigate the database schema to see how to change
the order by editing the tables.

On Jun 2, 1:31 pm, Christian Unger <christian.un...@mac.com> wrote:
> so we have added and deleted reports over time.
>
> and I want to put them in a certain order.
>
> every report obviosuly got it's own report ID
>
> now some queries show this id under e.g. report=7
>
> if I change this to a different number I get presented withan error
> like so:
>
> Error: When specified, the report number should be "29".
>
> even when earlier slots like 9,10,11 and so on are free trac tries to
> append the new report at the end of the report list rather than
> inserting it in the free slot which I specified in the query.
>
> What gives?
>
> __
> cu
> christian unger
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users[at]googlegroups.com
To unsubscribe from this group, send email to trac-users+unsubscribe[at]googlegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

DWinslow at aiminstitute

Jun 26, 2009, 5:24 AM

Post #3 of 5 (166 views)
Permalink

Re: re-ordering reports and queries [In reply to]

The reports are already listed in their own table. If we could embed a sql statement somewhere to generate the displayed list of reports, then we could have control over how it looks.

Actually, you probably can already do this by providing your own renderer for this admin panel, but I would have to go digging to find it. I'm no TRAC expert.

-----Original Message-----
From: trac-users[at]googlegroups.com [mailto:trac-users[at]googlegroups.com] On Behalf Of kurgbe
Sent: Friday, June 26, 2009 3:30 AM
To: Trac Users
Subject: [Trac] Re: re-ordering reports and queries

I have the same problem: I want to put some logical order in my long
list of reports.

It would be nice if the reports had a property "Display Order" that
could be changed in the edit screen of a report.

Meanwhile, I will investigate the database schema to see how to change
the order by editing the tables.

On Jun 2, 1:31 pm, Christian Unger <christian.un...@mac.com> wrote:
> so we have added and deleted reports over time.
>
> and I want to put them in a certain order.
>
> every report obviosuly got it's own report ID
>
> now some queries show this id under e.g. report=7
>
> if I change this to a different number I get presented withan error
> like so:
>
> Error: When specified, the report number should be "29".
>
> even when earlier slots like 9,10,11 and so on are free trac tries to
> append the new report at the end of the report list rather than
> inserting it in the free slot which I specified in the query.
>
> What gives?
>
> __
> cu
> christian unger

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users[at]googlegroups.com
To unsubscribe from this group, send email to trac-users+unsubscribe[at]googlegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

ryano at physiosonics

Jun 29, 2009, 4:31 PM

Post #4 of 5 (152 views)
Permalink

Re: re-ordering reports and queries [In reply to]

This seems to be discussed here:
http://trac.edgewall.org/wiki/TracReports#ChangingReportNumbering

On Jun 26, 1:30 am, kurgbe <denysmic...@googlemail.com> wrote:
> I have the same problem: I want to put some logical order in my long
> list of reports.
>
> It would be nice if the reports had a property "Display Order" that
> could be changed in the edit screen of a report.
>
> Meanwhile, I will investigate the database schema to see how to change
> the order by editing the tables.
>
> On Jun 2, 1:31 pm, Christian Unger <christian.un...@mac.com> wrote:
>
> > so we have added and deleted reports over time.
>
> > and I want to put them in a certain order.
>
> > every report obviosuly got it's own report ID
>
> > now some queries show this id under e.g. report=7
>
> > if I change this to a different number I get presented withan error
> > like so:
>
> > Error: When specified, the report number should be "29".
>
> > even when earlier slots like 9,10,11 and so on are free trac tries to
> > append the new report at the end of the report list rather than
> > inserting it in the free slot which I specified in the query.
>
> > What gives?
>
> > __
> > cu
> > christian unger
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users[at]googlegroups.com
To unsubscribe from this group, send email to trac-users+unsubscribe[at]googlegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

ryano at physiosonics

Jul 2, 2009, 11:35 PM

Post #5 of 5 (137 views)
Permalink

Re: re-ordering reports and queries [In reply to]

There is a plugin [1] that appears to allow reports to be re-ordered
via a web interface.

[1] http://trac-hacks.org/wiki/TracReportManagerPlugin

On Jun 29, 4:31 pm, RJOllos <ry...@physiosonics.com> wrote:
> This seems to be discussed here:http://trac.edgewall.org/wiki/TracReports#ChangingReportNumbering
>
> On Jun 26, 1:30 am, kurgbe <denysmic...@googlemail.com> wrote:
>
> > I have the same problem: I want to put some logical order in my long
> > list ofreports.
>
> > It would be nice if thereportshad a property "Display Order" that
> > could be changed in the edit screen of a report.
>
> > Meanwhile, I will investigate the database schema to see how to change
> > the order by editing the tables.
>
> > On Jun 2, 1:31 pm, Christian Unger <christian.un...@mac.com> wrote:
>
> > > so we have added and deletedreportsover time.
>
> > > and I want to put them in a certain order.
>
> > > every report obviosuly got it's own report ID
>
> > > now some queries show this id under e.g. report=7
>
> > > if I change this to a different number I get presented withan error
> > > like so:
>
> > > Error: When specified, the report number should be "29".
>
> > > even when earlier slots like 9,10,11 and so on are free trac tries to
> > > append the new report at the end of the report list rather than
> > > inserting it in the free slot which I specified in the query.
>
> > > What gives?
>
> > > __
> > > cu
> > > christian unger
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users[at]googlegroups.com
To unsubscribe from this group, send email to trac-users+unsubscribe[at]googlegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com