<?xml version="1.0" encoding="UTF-8"?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns="http://purl.org/rss/1.0/" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:syn="http://purl.org/rss/1.0/modules/syndication/" xmlns:admin="http://webns.net/mvcb/">
  <channel rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general">
    <title>gmane.comp.version-control.subversion.trac.general</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general</link>
    <description/>
    <syn:updatePeriod>hourly</syn:updatePeriod>
    <syn:updateFrequency>1</syn:updateFrequency>
    <syn:updateBase>1901-01-01T00:00+00:00</syn:updateBase>
    <items>
      <rdf:Seq>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33196"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33195"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33194"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33193"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33192"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33191"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33190"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33189"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33188"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33187"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33186"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33185"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33184"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33183"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33182"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33181"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33180"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33179"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33178"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33177"/>
      </rdf:Seq>
    </items>
    <image rdf:resource="http://gmane.org/img/gmane-25t.png"/>
    <textinput rdf:resource=""/>
  </channel>
  <image rdf:about="http://gmane.org/img/gmane-25t.png">
    <title>Gmane</title>
    <url>http://gmane.org/img/gmane-25t.png</url>
    <link>http://gmane.org</link>
  </image>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33196">
    <title>Re: Re[Trac] ply to closed ticket automatically reopen ticket</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33196</link>
    <description>&lt;pre&gt;You could get a dev to write you a small plugin that uses the
iticketchangelistener interface, similar to the last message in this
mailing list.  It would be a single component single file plugin, less than
a half hour of work for someone who was familiar with trac development.

-Nelson
On May 25, 2012 12:40 PM, "agami" &amp;lt;agamid-ZQ/q4+jdledeoWH0uzbU5w&amp;lt; at &amp;gt;public.gmane.org&amp;gt; wrote:

&lt;/pre&gt;</description>
    <dc:creator>Nelson Brown</dc:creator>
    <dc:date>2012-05-26T00:36:58</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33195">
    <title>Re: [Trac] ITicketChangeListener.ticket_changed() with a req parameter?</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33195</link>
    <description>&lt;pre&gt;It would probably be better to post this to the trac-dev mailing list,
where these kinds of issues are discussed more often.

Food for thought though, validate_ticket is a discussion between a single
user (possibly supplying incorrect parameters).

ticket_changed can be thought of in the same way, but may not originate
from a single request.  I'm thinking of tickets which are deleted or closed
on polled intervals, also batch modifications.  That or tickets which are
changed by functionality like what you are proposing (but on the same
server).  I can see that the request might be useful... but I'm not really
sold that it isn't a security risk.

Can you use the author who made the last change, and then communicate those
changes to the same plugin installed on the other server?  The end effect
being that the other plugin uses the ticket model on that server to do the
update with that author information.  This way you aren't transmitting
session authentication etc but still capture who made the change.

You'd a&lt;/pre&gt;</description>
    <dc:creator>Nelson Brown</dc:creator>
    <dc:date>2012-05-25T19:37:04</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33194">
    <title>Re[Trac] ply to closed ticket automatically reopen ticket</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33194</link>
    <description>&lt;pre&gt;
We use trac at my office (with email2trac plugin) and I was wondering if
anyone new how to set trac so that if a ticket is closed any updates to it
(like an email) would change the ticket from closed to reopened?
&lt;/pre&gt;</description>
    <dc:creator>agami</dc:creator>
    <dc:date>2012-05-25T16:40:08</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33193">
    <title>[Trac] ITicketChangeListener.ticket_changed() with a req parameter?</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33193</link>
    <description>&lt;pre&gt;Hi all,

TLDR: ITicketManipulator.validate_ticket() supplies a req parameter, ITicketChanged.ticket_changed() doesn't. Is this an intentional design decision, or would patch that adds an optional req parameter be considered for inclusion with Trac?

I'm currently finishing the remote ticket plugin I started long ago. The plugin will eventually allow a ticket to be linked to another ticket in another project - provided it's run using the ticketlinks branch of Trac.

In the plugin I am using ITicketChanged interface as a trigger to RPC update of the tickets in other projects. To authenticate to the other projects it's very useful to have a req instance - which the ticket_created()/ticket_changed() methods don't currently supply. For now I'm performing a horrid hack in ticket_validate() - saving a reference to req as an attribute on the Ticket instance.

Is there a better way to achieve my goal: when a ticket changes locally, attempt to update remote linked ticket to match - reusing any authentication tokens th&lt;/pre&gt;</description>
    <dc:creator>Willmer, Alex (PTS</dc:creator>
    <dc:date>2012-05-25T13:27:27</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33192">
    <title>[Trac] Slow ticket display</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33192</link>
    <description>&lt;pre&gt;Hello,

Recently I have noticed an extremely slow display of all ticket pages, 
it takes several minutes to display a ticket and most of the times it 
fails and displays the not_found page. All other pages (wiki, blog, 
reports, source display, etc.) are working well, only the ticket pages 
(ticket/1, ticket/2, etc.) are slow, which seems weird to me.

The problem seems to show only on one site, another site (same web 
hosting, shared Trac and Python install) seems to work well. The only 
difference is that the site which show the issue is used more frequently 
than the other (the other is private and used by 2-3 people and not so 
often).

I tought about cleaning the database from old sessions or something, but 
I don't know how to do that safely.

Can someone give me some suggestions on how to fix this issue ?

Using Trac 0.12.1 with Python 2.5-2.

Regards,
Marco.

&lt;/pre&gt;</description>
    <dc:creator>Marco Maccaferri</dc:creator>
    <dc:date>2012-05-25T08:53:13</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33191">
    <title>[Trac] Encode errors after upgrading to 0.12.3</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33191</link>
    <description>&lt;pre&gt;Hello,

I tried to upgrade Trac from 0.12.1 to 0.12.3 and I get a number of 
"UnicodeDecodeError: 'utf8' codec can't decode bytes in position 4-6: 
invalid data" errors from various places (not limited to a specific page 
or action, some pages are working others are not).

Upgrading with trac-admin does nothing.

What should I do to fix this issue ?

Regards,
Marco.

&lt;/pre&gt;</description>
    <dc:creator>Marco Maccaferri</dc:creator>
    <dc:date>2012-05-25T08:29:26</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33190">
    <title>Re: [Trac] agilo for trac</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33190</link>
    <description>&lt;pre&gt;Hi,

I have not use it, but I have read the installation instructions and
it seems that you can install it on top of an existing installation.
Your BitNami installation should include all the dependencies so you
just need to load the BitNami environment and follow the instructions
for installing Agilo for Trac.

You can load the BitNami environment settings by typing from the command line:

on Linux  linux_platform.png  and OS X mac_platform.png

$ cd installdir
$ ./use_trac

on Windows win_platform.png

Start Menu —&amp;gt; BitNami Trac Stack —&amp;gt; Use BitNami Trac Stack

On Fri, May 25, 2012 at 8:40 AM, Brettschneider Falk
&amp;lt;fbrettschneider-pW3Qwy1MDVzQT0dZR+AlfA&amp;lt; at &amp;gt;public.gmane.org&amp;gt; wrote:

&lt;/pre&gt;</description>
    <dc:creator>victoria</dc:creator>
    <dc:date>2012-05-25T07:15:45</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33189">
    <title>[Trac] agilo for trac</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33189</link>
    <description>&lt;pre&gt;Hi,
as I noticed there is Agilo for Trac I wonder how I would extend my existing Trac system if I wanted to use those additional features. Is it just to install another plugin? Would it be a replacement of my current Bitnami Trac Stack (0.12.2, Apache based)? Could I easily deinstall it if I dislike it? Looking at their web site it's not clear which way it integrates in an existing system.
And could you give me a hint about its quality/stability?

CU, F&amp;lt; at &amp;gt;lk

----
Falk Brettschneider
R&amp;amp;D Software
Baumer Optronic GmbH
www.baumer.com




Gesch?ftsf?hrer: Marcel Seeber * Dr. Oliver Vietze
Sitz der Gesellschaft: Radeberg
Amtsgericht Dresden: HRB 15379
Ust. ID: DE 189714583


&lt;/pre&gt;</description>
    <dc:creator>Brettschneider Falk</dc:creator>
    <dc:date>2012-05-25T06:40:37</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33188">
    <title>Re: [Trac] [trac] Problem with PrivateTicketsPlugin / VirtualTicketsPermissions</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33188</link>
    <description>&lt;pre&gt;

Just shooting in the dark but does the `anonymous` user have TICKET_VIEW
permissions by any chance?

Hope this helps,
&lt;/pre&gt;</description>
    <dc:creator>Olaf Meeuwissen</dc:creator>
    <dc:date>2012-05-24T23:12:27</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33187">
    <title>Re: [Trac] remove attachments</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33187</link>
    <description>&lt;pre&gt;I'll try that. Thanks!

Sent wirelessly from my BlackBerry device on the Bell network.
Envoyé sans fil par mon terminal mobile BlackBerry sur le réseau de Bell.

-----Original Message-----
From: Chris Shelton &amp;lt;cshelton-Pls0fCm8YjYbalU/voNBTqxOck334EZe&amp;lt; at &amp;gt;public.gmane.org&amp;gt;
Sender: trac-users-/JYPxA39Uh5TLH3MbocFFw&amp;lt; at &amp;gt;public.gmane.org
Date: Thu, 24 May 2012 12:46:44 
To: &amp;lt;trac-users-/JYPxA39Uh5TLH3MbocFFw&amp;lt; at &amp;gt;public.gmane.org&amp;gt;
Reply-To: trac-users-/JYPxA39Uh5TLH3MbocFFw&amp;lt; at &amp;gt;public.gmane.org
Subject: Re: [Trac] remove attachments

Have someone with the TICKET_ADMIN permission access the attachment page on
a ticket, and click the Delete Attachment button.

chris

On Thu, May 24, 2012 at 10:37 AM, Alana Dalley
&amp;lt;alanamariedalley-Re5JQEeQqe8AvxtiuMwx3w&amp;lt; at &amp;gt;public.gmane.org&amp;gt;wrote:


&lt;/pre&gt;</description>
    <dc:creator>alanamariedalley-Re5JQEeQqe8AvxtiuMwx3w&lt; at &gt;public.gmane.org</dc:creator>
    <dc:date>2012-05-24T17:07:06</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33186">
    <title>Re: [Trac] remove attachments</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33186</link>
    <description>&lt;pre&gt;Have someone with the TICKET_ADMIN permission access the attachment page on
a ticket, and click the Delete Attachment button.

chris

On Thu, May 24, 2012 at 10:37 AM, Alana Dalley
&amp;lt;alanamariedalley-Re5JQEeQqe8AvxtiuMwx3w&amp;lt; at &amp;gt;public.gmane.org&amp;gt;wrote:


&lt;/pre&gt;</description>
    <dc:creator>Chris Shelton</dc:creator>
    <dc:date>2012-05-24T16:46:44</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33185">
    <title>[Trac] remove attachments</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33185</link>
    <description>&lt;pre&gt;Hi there,

Just wondering if anyone knows how to delete an attachment once it has
been posted in TRAC.

&lt;/pre&gt;</description>
    <dc:creator>Alana Dalley</dc:creator>
    <dc:date>2012-05-24T14:37:37</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33184">
    <title>[Trac] [trac] Problem with PrivateTicketsPlugin / VirtualTicketsPermissions</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33184</link>
    <description>&lt;pre&gt;First of all I have to state that I'm pretty new to trac. I was instructed 
to set it up for our company and until now everything worked well during 
the setup.
The point is, we want to use a single trac instance for multiple companies. 
Each company representative will get an account to post tickets and view
their status. It is important that the guy of company A wont be able to 
read the tickets the guy of company B submitted. That's where these plugins 
comes into play.

I am using trac 0.12.3 and PrivateTicketsPlugin 1.1.1

I installed it properly I guess since it appears in the Plugins menu of the 
trac-administration. I also have the new permissions that come with the 
plugins in
the dropdown-box in the permissions menu. So I guess this all worked well.
I added the PrivateTicketsPolicy to the trac.ini file and obviously enabled 
the plugin there as well. The PrivateTicketsPolicy is placed before the 
existing Policies:

permission_policies = PrivateTicketsPolicy, DefaultPermissionPolicy, 
LegacyAttachm&lt;/pre&gt;</description>
    <dc:creator>jhNz</dc:creator>
    <dc:date>2012-05-24T09:08:10</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33183">
    <title>[Trac] Re: TracError: Cannot load Python bindings for PostgreSQL</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33183</link>
    <description>&lt;pre&gt;Ok, I found a fix for my problem. I removed my setuptools.pth file on my 
host (webfaction)

On Wednesday, 23 May 2012 21:41:56 UTC-4, David Genest wrote:

&lt;/pre&gt;</description>
    <dc:creator>David Genest</dc:creator>
    <dc:date>2012-05-24T10:25:20</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33182">
    <title>[Trac] Re: UnicodeDecodeError: 'utf8' codec can't decode bytes in position 85-88: invalid data</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33182</link>
    <description>&lt;pre&gt;Sorry, this was a quick shot - the value would be lost and can cause
the next error. Replace the line by

value = unicode(value.value, 'utf-8', 'ignore')

(cf. Python manual on unicode() builtin function) if this is
permissible (no try-catch).
I don't know yet what 'value' is used for, so it depends on the
purpose what to do with that in error case.
At least, the error was generated here and not in the plugin.

Reinhard

&lt;/pre&gt;</description>
    <dc:creator>Reinhard Wobst</dc:creator>
    <dc:date>2012-05-24T08:20:48</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33181">
    <title>[Trac] TracError: Cannot load Python bindings for PostgreSQL</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33181</link>
    <description>&lt;pre&gt;Hi, 

Not sure what changed in my hosting environment, but when I upgraded an 
extension (mercurial plugin that was failing), trac ceased to work saying 
it cannot load Python bindings for PostgreSQL. But everything was workihg 
before. 

I have psycopg2 installed. Trac was working.

Tried upgrading to latest trac. Still broken.

Note that I can load psycopg2 from a python prompt. I can also run without 
errors when I create an environment manually in a python shell.

The log posted below mentions exception while checking for upgrade. Is it 
possible to disable the upgrade checking to see if it's related to that? 
There is also an AttributeError in AdminModule. 

Can anybody help ? Thanks.

David.

Here is the relevant part of my log:

2012-05-23 20:11:24,790 Trac[env] ERROR: Exception caught while checking 
for upgrade: 
Traceback (most recent call last):
  File "/home/iekho/lib/python2.7/trac/env.py", line 667, in 
open_environment
    needs_upgrade = env.needs_upgrade()
  File "/home/iekho/lib/python2.7/t&lt;/pre&gt;</description>
    <dc:creator>David Genest</dc:creator>
    <dc:date>2012-05-24T01:41:56</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33180">
    <title>RE: [Trac] Re: Trac/SVN Post Commit Hook only partially working</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33180</link>
    <description>&lt;pre&gt;
I'm not a *nix user but it looks to me like there might be one of two issues: a) the www-data user (who is running the hook script) needs permission to /opt/ubersvn (i.e. add www-data to ubersvn group?) and you allowed only the other way round?  ...and/or b) you need to consider where `log.txt` is going to end up, apache will run the hook with a very minimal (empty!) environment...

~ mark c


&lt;/pre&gt;</description>
    <dc:creator>Cooke, Mark</dc:creator>
    <dc:date>2012-05-24T06:08:40</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33179">
    <title>[Trac] Re: UnicodeDecodeError: 'utf8' codec can't decode bytes in position 85-88: invalid data</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33179</link>
    <description>&lt;pre&gt;This seems not to be a problem with your plugin but with Trac in the
line

value = unicode(value.value, 'utf-8')

in trac/web/api.py in the Trac source (are you using Trac 0.12? Which
version exactly?).

Some illegal unicode value occured here. I am not a Trac developer and
do not know the circumstances, but before developer explain this error
in detail, a quick and dirty help may be to
catch this error:

try:
    value = unicode(value.value, 'utf-8')
except:
    # issue some warning here if you want or:
   pass

Of course, you have to change the Trac source code to this purpose but
this should be no problem if you have the permissions.

HTH, Reinhard

&lt;/pre&gt;</description>
    <dc:creator>Reinhard Wobst</dc:creator>
    <dc:date>2012-05-23T22:58:41</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33178">
    <title>[Trac] Re: Trac/SVN Post Commit Hook only partially working</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33178</link>
    <description>&lt;pre&gt;Okay,

     So, I have tracked this down to a permissions problem. If I run:

*chmod -R o+rw /var/trac*

The ticket gets updated successfully. One can easily see why I wouldn't 
want to do this.

My permissions are set up as follows.

Everything under* /opt/ubersvn* is set to group *ubersvn *and owner *ubersvn
*
Everything under */var/trac* is set to group *www-data* and owner *www-data*
The user *ubersvn *is a member of the *www-data* group so it has permission 
to write to the *trac.db* file */var/trac/sites/web/db/trac.db* and it's 
directory. Thus the commit hook appears to work and refreshes the 
repository on the trac installation (i.e. I can see the commit message in 
the timeline)

Now, in my commit hook script I attempted to add some logging like this: */var/trac/sites/web 
changeset added "/opt/ubersvn/repositories/web" "refs #270" &amp;gt;&amp;gt; log.txt*

I got a permissions error.

So I guess the question is what user needs permission to what in my trac 
installation to update the dang tickets OR which direc&lt;/pre&gt;</description>
    <dc:creator>Christian</dc:creator>
    <dc:date>2012-05-23T20:42:51</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33177">
    <title>Re: [Trac] Custom ticket query for new and reassigned tickets</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33177</link>
    <description>&lt;pre&gt;
This triggered something in the back of my mind...
http://stackoverflow.com/questions/1991697/mysql-date-and-time-functions-dont-exist

I'm guessing they're running sqlite not mysql as the DB backend for
Trac. But that should help you with composing queries better.

I don't use the custom sql reports in trac usually... I've generally
tried to make do with the capabilities of the TicketQuery macro
embedded in a wiki page for my needs regarding reporting. What I have
setup looks like this:
== My Tickets ==

{{{#!td style="vertical-align: top; width: 33%;" align=center
[[TicketQuery(owner=$USER,status!~=closed,list,group=priority)]]
}}}
{{{#!td style="vertical-align: top; width: 33%;" align=center
[[TicketQuery(owner=$USER,status=in_QA,list)]]
}}}
{{{#!td style="vertical-align: top; width: 33%;" align=center
[[TicketQuery(owner=$USER,status=closed,list)]]
}}}

And let's me at a glance see my open tickets, ones that have been
assigned to QA for assessment and my closed tickets. I usually key
this additional by &lt;/pre&gt;</description>
    <dc:creator>Benjamin Lau</dc:creator>
    <dc:date>2012-05-23T16:19:52</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33176">
    <title>[Trac] Custom ticket query for new and reassigned tickets</title>
    <link>http://permalink.gmane.org/gmane.comp.version-control.subversion.trac.general/33176</link>
    <description>&lt;pre&gt;Hello everybody,

I hope to find some help here with custom ticket queries in sql for trac 
that will make my life easier ;)

First of all, we are using a hosted trac on hosted-projects.com. So my 
possibilities may be limited or some functionality may be missing but 
custom ticket queries in sql seem to work, although not fully as I would 
expect e.g. CURDATE() function is not working.

I would like to have two queries:

1) All my new tickets

When I try a custom query without sql with owner=michael and status=new, it 
just gives all the tickets that are assigned to me. 

But what I consider new tickets are
- tickets that have me as the owner and there was no change in the 
ownership, so basically all tickets that are created with me as the owner 
and are not touched again
or
- tickets that I own that have been assigned to me for the first time 
(which means that I have not been owner of the ticket before)

2) All tickets reassigned to me

This query should show me tickets that I own and have been assigned &lt;/pre&gt;</description>
    <dc:creator>Michael</dc:creator>
    <dc:date>2012-05-23T16:01:09</dc:date>
  </item>
  <textinput rdf:about="http://search.gmane.org/?group=$group=gmane.comp.version-control.subversion.trac.general">
    <title>Search Engine</title>
    <description>Search the mailing list at Gmane</description>
    <name>query</name>
    <link>http://search.gmane.org/?group=$group=gmane.comp.version-control.subversion.trac.general</link>
  </textinput>
</rdf:RDF>

