[rt-users] Cannot query with more than one watcher using AND

[Schultz, Eric]

Okay, finally back from vacation and installed 3.5.6.  Still doesn't work.  Other similar queries that don't work:

Ticket has requestors: jesse at bestpractical.com, jvincent at bestpractical.com
Query: Requestor.EmailAddress LIKE 'jesse' AND Requestor.EmailAddress LIKE 'jvincent'
Result: returns 0 tickets, should return one

Ticket has requestor: jesse at bestpractical.com
Ticket has AdminCc: jvincent at bestpractical.com
Query: Requestor.EmailAddress LIKE 'jesse' AND AdminCc.EmailAddress LIKE 'jvincent'
Result: returns 0 tickets, should return one

There are a lot of enumerations of this that fail.  I'd be glad if other people could create a few test tickets and verify this problem.

I think this requires a rethought in how watchers/principals are set up in the database (i.e., it's not a problem with the query building engine).  If you look at the raw SQL produced that is sent to the DB, you'll see where there are collisions in the select that negate any hope for rows to be returned.  I can provide a sample if need be.

-----Original Message-----
From: Jesse Vincent [mailto:jesse at bestpractical.com]
Sent: Friday, December 09, 2005 4:46 PM
To: Schultz, Eric
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Cannot query with more than one watcher using
AND


On Fri, Dec 09, 2005 at 04:31:05PM -0800, Schultz, Eric wrote:
> Please see this ticket I filed for RT:
> http://rt3.fsck.com/Ticket/Display.html?id=7197
> 
> I'm not sure why there's a lack of understanding, I thought it was pretty straight-forward.  To re-iterate my original point...  Consider the following query run at rt3.fsck.com:
> 
> Requestor.EmailAddress = 'jesse at bestpractical.com' AND Cc.EmailAddress = 'arthur at West.NL'
>

And what I thought I'd asked was how many tickets arthur at west.nl was the
CC on. But now I think I get it. Could you do me the favor of trying
this query with RT 3.5.6? We've done a fair bit of work on that section
of the Query Building engine.