trac question: search with AND?

[Noah Kantrowitz]

> -----Original Message-----
> From: devel-bounces at lists.laptop.org [mailto:devel-
> bounces at lists.laptop.org] On Behalf Of Martin Langhoff
> Sent: Monday, September 22, 2008 3:00 PM
> To: pgf at laptop.org
> Cc: devel at lists.laptop.org
> Subject: Re: trac question: search with AND?
> 
> On Tue, Sep 23, 2008 at 4:52 AM,  <pgf at laptop.org> wrote:
> > this thread ended in the trac tickets, so to be sure no one
> > was misled by my claims:  it turns out i was completely mistaken
> > (apparently from misreading some specific search results)
> > about trac's search behavior.  multiple search terms are indeed
> > AND'ed together in the search, as one would expect they should
> > be.
> 
> Well, I sometimes do wish I could OR them. Many tasks/bugs on the XO
> side have a 'schoolserver' keyword, used to indicate that they related
> to interop with the XS. So the XS "tasklist" is
> 
>      component=schoolserver  OR keyword contains schoolserver
> 
> I haven't found a way to do this on trac... other than running 2
> queries :-/

SELECT ... FROM ticket WHERE component='schoolserver' OR
position('schoolserver' in keywords) != 0;

--Noah